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
