Ralf, I think there are three indexes neccessary: confidentiality, name and city.
Do you need all data in memory? The 20 secs to read all data depends on - your network bandwidth - your server performance - your server RAM - number and size of columns in your table Hth, Tilmann Starke SOFTWORK GmbH Help to prevent global warming by writing cool software. -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Im Auftrag von Ralf Schneider Gesendet: Montag, 22. April 2002 16:04 An: [EMAIL PROTECTED] Betreff: Performance problems Hi, my application reads about 100.000 records from the DB during startup (it will be even more in the future!). This takes about 20 seconds. Is that normal for such a number of records? For me, it seems a bit to long. The executed SQL statement looks like this: sql = "SELECT \"cid\", \"name\", \"city\", \"client\" " "FROM company " "WHERE \"confidentiality\" <= " + conf + " " "AND \"name\" LIKE '" + mPattern + "' " "ORDER BY \"name\" DESC, \"city\" DESC"; I created an index for the 4 selected columns. Is there anything that is time consuming in this statement? Or is the performance for 100.000 records OK? Regards, Ralf. -- ## Ralf Schneider ## B-connected Linux Solutions GmbH - Linux f�r den Mittelstand ## Dennis-Gabor-Str. 2, 14469 Potsdam ## www.b-connected.de _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
