Php shows query results. I connected to MSSQL using PHP, and then used $ SQL & nbsp; exec & nbsp; Report_a2013zhou_kpsfpout & nbsp ;, 2013-1---1-31,; this statement executes the stored procedure and finds that the displayed results are incomplete, nearly 1000 fewer php queries than the results displayed by direct execution in the database query analyzer
I use PHP to connect to MSSQL and then use
$ SQL = "exec Report_a2013zhou_kpsfpout'', '2017-1-1 ', '2017-1-31 ','','','',''";
This statement executes the stored procedure and finds that the display results are incomplete. more than 1000 results are displayed after I directly execute the statement in the database analyzer, I found more than 6000 rows in the database, and the query on the webpage was very slow. after half a day, more than 5000 rows came out,
What is the reason? is there a limit on the number of rows and query time used in the stored procedure?
Php ms? SQL
Share:
------ Solution --------------------
After waiting for a long time... it is clear that so many lines of browsers cannot be used at a time.
Batch display is not enough
