Find the total database record count

dansot · 2013-01-02 00:07:44

How do I find the total number of records stored?

ab · 2013-01-02 05:08:58

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).

dansot · 2013-01-03 07:22:57

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

ab · 2013-01-03 08:15:54

Happy we helped.

mORMot Open Source

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

Find the total database record count

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

Re: Find the total database record count

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

Re: Find the total database record count

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

Re: Find the total database record count

Board footer