|
|
|
|
TServerCountQuery 1.0 |
Version: 1.0 |
Shareware By: Francesco Pucino |
| Downloads: 0 Hits: 131 |
Source: YES |
report broken  |
Sponsored Links:
Description of TServerCountQuery :
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.
|
|
|
User Reviews: |
|
|
Related: |
OLEDB Direct Components Suite allows direct access to OLEDB interfaces from Borland (c) Delphi and C++ Builder. OLEDB Direct Components Suite is a...
|
Shareware |
By: Viatcheslav V. Vassiliev |
TPictPrev is a component to display images. The images can be loaded / saved from / in files and from / in strames. This way it can be used also...
|
Shareware |
By: Istvan Mesaros |
SQLMemTable is a fast and easy-to-use in-memory table and query components library for Delphi and C++ Builder. It does not require BDE and provides...
|
Freeware |
By: AidAim Software |
Demo utility for working with mdb-files via ADO (source code):Enumerating tables, view columns name and type, view records,Executing SQL query,...
|
Freeware |
By: Vladimir Afanasyev |
Dezign for databases is a database development tool using an entity relationship diagram. It visually supports the lay out of the entities and...
|
Shareware |
By: Rick van Dijk |
Interface with your GPS receiver.
|
Shareware |
By: Axolot Data |
Read and write Metastock quote files.
|
Shareware |
By: Axolot Data |
XLSReadWriteII.NET for Delphi 2005/2006 and others, Win Forms Use this version for creating Win Forms applications with Delphi, Visual Studio and...
|
Shareware |
By: Axolot Data |
Syndicate Pro multi-platform compatible. Syndicate Pro is server software for managing and distributing news headlines and other content over the ...
|
Shareware |
By: Sujit |
Interactive SQL for PostgreSQL is a powerfull database utility. It allows: Build SQL queries using SQL Editor with SQL syntax highlighting and SQL...
|
Shareware |
By: Sujit |
|
|
|
|
ASP
