> Problem: > I'm executing a select statement over joined tables. As a > result I get 10 > 000 records. > But I only want to get the record's 20-31 (for example). > This is a typical function of search-engines.
Most of the programming interfaces have a method to move to a specific record in the result set. The rows skipped are not copied to the client. If you stop reading rows after row 31, then the remaining rows are also not copied to the client (except for a few which are already copied to the client). This will not solve all your problems as the database might still create a temporary result set of all the 10000 records. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
