SQLite3ProfessionalPlugin

I plan to release final version next week (with also RB 5.5 compatibility). In the meantime I have written a small RB project to show you why it is so important to have access to the sqlite3 virtual machine and what real numbers are when it is correctly used.

As a real world test, we have created an sqlite 3 database with 10 columns and 200,000 rows (database size is about 200MB), and we have execute a "SELECT * from test" query.
These are the results of the test:

	SQLite3Professional	REALSQLDatabase
Memory usage:	44 Bytes	200 MB
Query Time (sec.):	0.0001	15.879
Time to scan RecordSet (sec.):	4.331	0.037
Total Time (sec.):	4.331	15.916

As you can see SQLite3ProfessionalPlugin is always 300% / 400% faster than REALSQLDatabase and it requires about near null memory.

You can run this test yourself, just download the full REALbasic project here (12KB - RB2006 syntax)

I have posted more details in the forum section.