Eonblast/Emysql — Issue #22: performance improvements, where to start
Author: bvdeenen
Created: 2012-03-05 14:12:37+00:00
State: open

Hi all

I'm running into some performance issues, and would like to ask for your input on where to start with trying to improve the emysql performance.

My table contains 5 small integer columns, but can have a million (or more rows). Doing "select * from ..." with the normal mysql client takes about two seconds. Doing the same with emysql:execute takes about a 25 seconds.

Do you already have any idea where the bottleneck is, or should I start profiling everything? Should I make my query return smaller chunks of data?

Just asking for some input, I do have the time to work on it.

Thanks

Bart van Deenen, contractor at Spilgames.com