cause for long query execution?
#4

I seem to remember you having 13,000 rows. You should know that searching through a table using a string as a key is very, very slow in comparison to a surrogate integer id key. Especially if there is no index on that string field as in that case a full table scan is required which is much slower, still.
Reply


Messages In This Thread
cause for long query execution? - by Type-R - 18.03.2016, 15:40
Re: cause for long query execution? - by AndySedeyn - 18.03.2016, 15:55
Re: cause for long query execution? - by Type-R - 18.03.2016, 16:34
Re: cause for long query execution? - by Vince - 18.03.2016, 16:50
Re: cause for long query execution? - by Type-R - 18.03.2016, 18:59

Forum Jump:


Users browsing this thread: 2 Guest(s)