BorlandTalk.com

Tuong Vu · Guest

HI everyone,
I'm connecting to Progress 9D database with JBuilder 2006.
-- With database pilot via jdbc.
When I do a simple select statement (select * from TABLE where column like 'lala%') in this environment from a large table (1 million records) the response was instantly.
--But in my Application with DataExpress object via jdbc.
When I do the same query using queryDataset with the optimization applied (Metadataupdate.NONE, LOAD as needed, assign tableName, etc..) and bind it to a JdbTable. The performance here is really slow up to two minutes of waiting time. I have try every possible help to improve query performance suggested by many Jbuilder Documents, but no luck yet.

How does Database Pilot get the response so fast?
Does QueryDataset alter the select statement?
Is there a way to bind java.sql.ResultSet into DataSet?

Any help will be appreciated, Thank you.