Hallo,

Try to display list of klients from database with 24 000 records.
Using JBuilder with standard controls (querydataset and jdbtable)
Two identical tables with 24000 records.
jaybird 2.0.1. and last postgresqljdbc.
time loading all records:

jaybird: 30 seconds

postgre 2 seconds

What is going on ?

What im doing wrong ?



Postgre:
database1.setConnection(new ConnectionDescriptor(
"jdbc:postgresql://localhost:5432/test", "postgres", "qwerty", false,
"org.postgresql.Driver"));
queryDataSet1.setQuery(new QueryDescriptor(database1, "SELECT \"T_KLIENT\".\"ID\",\"T_KLIENT\".\"NAZWA_PELNA\",\"T_KLIENT\".\"NAZWA_KROTKA\" " +
"FROM public.\"T_KLIENT\"", null, true, Load.ALL));
jdbTable1.setDataSet(queryDataSet1);

Firebird:
database1.setConnection(new ConnectionDescriptor(
"jdbc:firebirdsql:localhost/3050:c:\\bazy\\kbase.gdb",
"SYSDBA", "masterkey", false, "org.firebirdsql.jdbc.FBDriver"));
queryDataSet1.setQuery(new QueryDescriptor(database1,
"SELECT T_KLIENT.ID,T_KLIENT.NAZWA_KR,T_KLIENT.NAZWA_PELNA FROM T_KLIENT", null, true,
Load.ALL));


Best regards
Martin





---------------------------------
Yahoo! Messenger NEW - crystal clear PC to PC calling worldwide with voicemail

[Non-text portions of this message have been removed]