While working on a script (in Perl), I discovered that MySQL performs very differently depending on the method used to retrieve a data row. What I need to do is walk through a set of 5000+ rows of a table with 110 columns. I have tried four different versions, and instead of elaborating and discussing, I will simply write down the method used and the execution time
Ray: Having the same problem. Very frustrating. Luckily, for some reason my released version worked on the iPad itself, but now I can't get it to run in the simulator. Getting no such table, which I'm guessing is an initialization error. Will continue to investigate.