How to improve ODBC performance

["johnber" <johnber(at)sparqnet(dot)net>]

Sir:

I use ODBC driver 8.02 in my Delphi 7 application, and the
ConnectionString="DRIVER={PostgreSQL
Unicode};DATABASE=mydb;SERVER=x.x.x.x;PORT=5432;UID=postgres;PWD=password;Protocol=6.4",

When I send a query--
"SELECT * FROM mytable WHERE grade=4"
to a database which stores 90000 records, it takes about 30
minutes. The performance is too bad.

On the other side, I use ZeosLib's VCL components, It only
takes 30 seconds.

Is there a way to improve ODBC's performance like tunning
the ConnectionString?

I'm sorry for my poor English, below is written in
Traditional Chinese(BIG5) if somebody can read it.  :-P

Thank you sincerely

------------------------------------------------------------
我的 Delphi 7 程式嘗試使用 ODBC 8.02 開發, 在 ADOConnection
的 ConnectionString 如上文, 然後送出查詢至一個存有約 90000
萬筆記錄的資料庫, 查詢命令為--
"SELECT * FROM mytable WHERE grade=4"

但效率太差了, 約需 30 分鐘.

而我若以 ZeosLib 的 VCL 元件查詢只需 30 秒, 請問為什麼效率會
相差這麼大, ODBC 的部份可以藉由調整設定來提高效率嗎? 例如改
變 ConnectionString 的寫法.

謝謝