#1 2013-01-02 00:07:44

dansot
Member
Registered: 2012-11-12
Posts: 25

Find the total database record count

How do I find the total number of records stored?

Offline

#2 2013-01-02 05:08:58

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,660
Website

Re: Find the total database record count

Of the whole database?

Use a loop over all tables in the TSQLModel, then retrieve the count of each, using TSQLRest.TableRowCount() method.
It is very fast with SQLite3, but may be slow with some external DB (like FireBird).

Offline

#3 2013-01-03 07:22:57

dansot
Member
Registered: 2012-11-12
Posts: 25

Re: Find the total database record count

Thank you for your patient help ab.  I am now successfully using SynSQLite3 for my project and it is working very well.

Offline

#4 2013-01-03 08:15:54

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,660
Website

Re: Find the total database record count

Happy we helped.
big_smile

Offline

Board footer

Powered by FluxBB