Hi Folks --
I'm working on a scientific data warehousing setup using MySQL (currently
running 4.1.13 on SPARC/Solaris 9), and using the C prepared statements API for
pulling numeric data in and out.
So, here's my question: How can I find out how many rows are being returned by a
query, without using mysql_stmt_store_result() to buffer all the rows back to
the client? The problem with buffering it all back is that result sets are
usually gigabytes, sometimes even terabytes -- there's just no way that most of
the client systems can stuff that all into memory. I need to find a decent way
to break up the result sets into chunks, but doing that is tricky without
knowing just how many rows are coming back :)
I've tried playing with SQL_CALC_FOUND_ROWS in the queries, but I don't think I
can execute a second query via the same database connection before dealing with
the entire result set from the main query. Is there a good way to execute
multiple queries in parallel via one connection?
Suggestions, questions, even flames welcome. Thanks in advance!
ken
===========================================================================
"Diplomacy is the weapon of the Civilized Warrior"
- Hun, A.T.
Ken Gieselman [EMAIL PROTECTED]
Endlessknot Communications http://www.endlessknot.com
===========================================================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
