RE: Slow Database

2002-02-13 Thread Tim Stephenson
turn 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

RE: Slow Database

2002-02-13 Thread Roger Baklund
* Neil Tompkins > > Are there any settings I can set to limit the number of records returned ? Yes, the LIMIT clause of the SELECT statement: http://www.mysql.com/doc/S/E/SELECT.html > -- Roger query - Before posting, please

Slow Database

2002-02-13 Thread Neil Tompkins
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 nu