Searching through multidimensional arrays
View Single Post
10-04-2009, 05:35 PM
Join Date: Sep 2007
Originally Posted by
I timed the two different approaches. Doing 16 sql queries was way slower than looping the arrays.
Sql query time: 0.002832 msec
Array looping time: 0.000097 msec
But I guess that if there were thousands of products the sql would be faster. I only have about 30 in my test.
That is because of connection overheads associated with each individual query. Can you show us the query? I've never seen a need to use that many queries for one task before.
View Public Profile
Send a private message to Village Idiot
Find More Posts by Village Idiot