Why My php, html page is loading too slow? how to increase my page speed ?

Thejashwini L 1 Reputation point
2021-11-22T06:15:34.453+00:00

If I use so many sql queries it is taking too much time to load may be how to over come from this problem anyone please help me out this.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,589 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. CathyJi-MSFT 20,671 Reputation points Microsoft Employee
    2021-11-22T06:41:15.74+00:00

    Hi @Thejashwini L ,

    Long processing of database queries is often the cause of slow pages loading. Often the reason for this is incorrectness of queries writing, lack of competent tables indexing, bulky and too complex requests and etc. Refer to this blog How To Make PHP Websites Run Faster?

    Your issue is that your php, html page is loading too slow. Many factors will affect the load of php page. If SQL server query is not the root cause for your issue. We could not give you a better help. SQL server general tag that talking issues about SQL server Tech issues.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

    No comments

  2. Olaf Helper 26,056 Reputation points
    2021-11-22T08:09:56.39+00:00

    That's to less on information.

    Please post table design as DDL, some sample data as DML statement and the expected result.
    Also check the execution plan of your queries to see if a suitable index is used.

    No comments