That is not a normal response from a typical SQL query. It is odd to me that DataTables returns the statement "Showing 1 to 10 of 349 entries (filtered from 2,173,873 total entries)" Why is it even taking the time to gather the information about the total number of entries. This (30 seconds or so) is about how long it takes to query this type of information in the SQL system if you are trying to query a column that is not indexed. When I run the same query through the DataTables system, it takes about 25 seconds to process the same data (about 300 rows or so). If I run a third party tool like RazorSQL on the IIS/PHP server (or anywhere else on the network for that matter), I can get the results by customer in less than 1 second (about. I have started out with the Simple Server Side Processing example and have slowly adopted it for MSSQL. Basically, this is a table of all the orders in an accounting system.
I have IIS/PHP installed on one server and the MSSQL server is on another box in the same environment. I have all the columns that I am doing my where clauses on properly indexed. It is on a very high end DB system that performs exceedingly quickly. Okay, so I have a MSSQL database with about 2 Million Rows in it.
0 kommentar(er)
