| Subject | Database categories and conditions |
|---|---|
| Author | coderefectory |
| Post date | 2010-02-15T19:24:59Z |
Hi,
I tested my new Firebird 2.1 database to 100 mil. records (16.9GB size).
I created indexes and everything work perfect, even through USB 1.0 extern HDD.I realized that LIKE, COUNT, MAX conditions work to slow and I avoid them.
In which category belongs my database with 100 million records in the table ... a small, medium, or large database?
I found that condition 'STARTING WITH' is much better than 'LIKE'...Is there some other condition and method suitable for large database?
Is it true that for user interface the best practice is using Cursors not Querys?
I tested my new Firebird 2.1 database to 100 mil. records (16.9GB size).
I created indexes and everything work perfect, even through USB 1.0 extern HDD.I realized that LIKE, COUNT, MAX conditions work to slow and I avoid them.
In which category belongs my database with 100 million records in the table ... a small, medium, or large database?
I found that condition 'STARTING WITH' is much better than 'LIKE'...Is there some other condition and method suitable for large database?
Is it true that for user interface the best practice is using Cursors not Querys?