Query rows Question?

#1

Does anyone know if there's a limit to the number of rows returned
in a select query in mysql++? I'm seeing some mysterious errors in
my test code that may or may not be related to the result set size,
and am curious if anyone has run into something like this (or if
there's a different way results should be obtained if you know
the set is going to be massively large).

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

#2

Earl Miles wrote:

Quote:

Does anyone know if there's a limit to the number of rows returned in a
select query in mysql++? I'm seeing some mysterious errors in
my test code that may or may not be related to the result set size,
and am curious if anyone has run into something like this (or if
there's a different way results should be obtained if you know
the set is going to be massively large).

And to answer myself, I see that large queries should probably use
a use() rather than a store() query.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

#3

You can use the LIMIT option to the SELECT clause to get results in
chunks.=20

Quote:

-----Original Message-----
From: Earl Miles [mailto:merlin (AT) logrus (DOT) com]=20
Sent: Thursday, March 31, 2005 5:41 PM
To: MySQL++ Mailing List
Subject: Query rows Question?
=20
Does anyone know if there's a limit to the number of rows=20
returned in a select query in mysql++? I'm seeing some=20
mysterious errors in my test code that may or may not be=20
related to the result set size, and am curious if anyone has=20
run into something like this (or if there's a different way=20
results should be obtained if you know the set is going to be=20
massively large).
=20
--=20
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: =20
http://lists.mysql.com/plusplus?unsu...) f5 (DOT) com
=20
=20

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query rows Question?

mailing.database.mysql-plusplus mailing.database.mysql-plusplus

Query rows Question? - 03-31-2005 , 08:41 PM

Re: Query rows Question? - 03-31-2005 , 08:51 PM

RE: Query rows Question? - 03-31-2005 , 08:53 PM