Welcome Guest, Not a member yet? 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 ...
3,438 Views
3 Replies
02-02-2017, 02:45 PM
shedger
    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 ...
3,438 Views
3 Replies
01-31-2017, 10:29 PM
shedger

Theme © iAndrew 2016 - Forum software by © MyBB