TServerCountQuery (V1.0 D5) |
|
|
|
領航天使
站長   發表：12216 回覆：4186 積分：4084 註冊：2001-07-25 發送簡訊給我 |
名稱:TServerCountQuery
版本:V1.0
原始程式:需購買或註冊 註冊網址
適用:(D5)
版權種類:分享軟體(Shareware)
作者:Francesco Pucino
出處網址:http://web.tiscalinet.it/delphipage
說明:
It's a discendent of standard TQuery. It allows to fix the (very) slow method to count result
records used in the standard query component: fetch each record from the server and store it
on the client, increasing a counter... If you use local DBMS as Paradox or dBase you don't are
afflicted by poor performances, but if you use DBMS server as MS SQL Server or Oracle, each
time your code call the RecordCount method you assist to HD light flashing, network traffic
increasing and a very long response time.
More results are in the query recordset, more problems you have... More time you use the RecordCount method on the same query, more time you have the problem... TServeCountQuery solve the problem, asking directly to the DBMS the number of records retrieved: fast, easy and clear. You can use this component as a standard TQuery component, all the work is done in background and if some error occours, will be fired an OnCountError event and the standard RecordCount method will be called. You can access too to the LastCountSQL string propery to see the SQL statemant used to retrieve the record count in the current query.
------
～～～Delphi K.Top討論區站長～～～ |
發表時間：2000-09-14 00:00:00
IP:0.0.xxx.xxx 未訂閱
附加檔案：系統時間：2024-05-05 19:29:15
聯絡我們 | Delphi K.Top討論版
| 本站聲明 |
|
1. 本論壇為無營利行為之開放平台，所有文章都是由網友自行張貼，如牽涉到法律糾紛一切與本站無關。 2. 假如網友發表之內容涉及侵權，而損及您的利益，請立即通知版主刪除。 3. 請勿批評中華民國元首及政府或批評各政黨，是藍是綠本站無權干涉，但這裡不是政治性論壇！ |