Hello, ill try to get the last ten rows without fetching the whole table (ODBC !)
the table CREATE TABLE logtab ( ts timestamp default TIMESTAMP, username varchar(255) NOT NULL default '', domain varchar(255) NOT NULL default '', action varchar(255) NOT NULL default '', data varchar(255) NOT NULL default '' ) in postgres & mysql the query is: SELECT * FROM logtab WHERE domain='$fDomain' ORDER BY ts DESC LIMIT 10 my first idea was: SELECT * FROM logtab WHERE domain='$fDomain' AND ROWNO < 11 ORDER BY ts BUT If I've read the doc right maxDB does first fetch the fits ten rows an then order it. any help`? regards jph ___________________________ Dipl.-Ing. Jens-Peter C. Hillers Remote Web Services GmbH Tel: +49 40 25 49 06 22 Fax: +49 40 36 00 67 27 Email: [EMAIL PROTECTED] ____________________________
