Neil, You can limit the number of records returned by any query by appending " LIMIT x, y " or "LIMIT y" where x is the offset of the first row you want, and y is the maximum number of records to return.
For example, "select * from testtable LIMIT 2 " would return the first 2 rows from the table. LIMIT 5, 10; would return rows 6 through 15 of the table. Regards, Tim ---- SQL, Query -----Original Message----- From: Neil Tompkins [mailto:[EMAIL PROTECTED]] Sent: 12 February 2002 23:20 To: [EMAIL PROTECTED] Subject: Slow Database Hello, I'm writing a application to connect to a mySQL database over a modem link. Since the link is very slow, I need to limit the number of records returned when the database and tables are opened. I connect to the database using a ODBC driver. Are there any settings I can set to limit the number of records returned ? Thanks for any help. Neil --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
