Re: C API -- huge result sets slowin me down

2004-07-01 Thread Egor Egorov
"Matt Eaton" <[EMAIL PROTECTED]> wrote: Try to profile application from that point ... >if (mysql_real_query(&dbase,sqlBuff,strlen(sqlBuff))) { >printf("Pool Attributes Select Failed... dumbass\n"); >fprintf(stderr, "Error: %s\n", >

Re: C API -- huge result sets slowin me down

2004-06-29 Thread Dobromir Velev
Hi, The only thing that could slow you down is that the genAttrib array will take more and more memory as the result set grows. I would recommend you to create a function that uses the mysql row directly instead of creating this huge array. something like while ((row = mysql_num_rows(result))

C API -- huge result sets slowin me down

2004-06-28 Thread Matt Eaton
Hi all, I was hoping this was the right place for a question about the C API. I've been grabbing result sets from tables in the C API for a few years now, but I'm starting to work with result sets that are big enough to bog me down. Of course, the result sets aren't insanely big, so I was wonderi