CodeIgniter Forums - Search Results

Home
Forums
Members
Search
Help
New topics
Todays topics
Website

Register Sign In

Search Results

Thread: Slow DB queries with MS-SQL
Post: RE: Slow DB queries with MS-SQL

burgoyn1 Wrote: (02-01-2017, 03:09 AM) -- Indexes. Somewhere in your query whatever you are trying to search on is not indexed so to find the data it has to read all 17,000 rows. If you set an index ...

Thread: Slow DB queries with MS-SQL
Post: Slow DB queries with MS-SQL

Hi, We are running CI and and MS-SQL however when doing a sql query such as select * from tblTest, it can take over 22 seconds to get a result back (of say 17,000 rows) compared to the same query ...