item database query

[Novo]

Originally Posted by Googi

If you really want to know, test both methods by using a timeout. Have a script start a timeout, do some stuff (probably quite a bit of stuff) using the first method, and then save the value of the timeout to a variable/echo it/whatever. Then do the same with the second method (of course, make sure that the stuff done with the second method is the same as for the first).

Directly accessing the value is systematically faster than accessing the value and comparing a bunch of values inside. ( It could be slower on loading up, but once loaded, it is fairly fast ).

[Googi]

Originally Posted by Novo

Directly accessing the value is systematically faster than accessing the value and comparing a bunch of values inside. ( It could be slower on loading up, but once loaded, it is fairly fast ).

But you could find out how much faster.

[Novo]

Originally Posted by Googi

But you could find out how much faster.

N times faster. N being the size of the array.

[Googi]

Originally Posted by Novo

N times faster. N being the size of the array.

If you don't count the time it takes to open and read the file, sure.

[Novo]

Originally Posted by Googi

If you don't count the time it takes to open and read the file, sure.

Which is what caching does. You read it from file, you cache it to memory. The load-up times would differ. Taking the average amount of time it took to load up over the average life-span of the variable and you'll conclude that the load-up times are inconsequential.