TalkPHP - View Single Post - Searching through multidimensional arrays

Swiftaxe · 10-04-2009, 03:21 PM

Village Idiot,

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.

10-04-2009, 03:21 PM	#4 (permalink)
Swiftaxe The Visitor Join Date: Oct 2009 Location: Sweden Posts: 3 Thanks: 1	Village Idiot, 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.