-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 03/06/2011 03:04 PM, Max Vlasov wrote:
> I don't think I need a solution that complex. 

You need to be very careful with your terminology :-)

As for getting other data into your database, just do a .dump of a different
SQLite database and run it.

If you are looking for something to exercise your database then I suggest
running this which will spew out SQL you can run.

  http://www.sqlite.org/src/finfo?name=tool/mkspeedsql.tcl

I have an enhanced version in my project:

  http://code.google.com/p/apsw/source/browse/tools/speedtest.py

You can give it a scaling factor (roughly how many seconds it should take),
include Unicode in addition to plain ascii, use larger data items etc.
Sample command line:

  speedtest.pt --unicode 5 --scale 10 --dump-sql /tmp/test.sql

In the big picture you are right about multiple connected databases not
being from different VFS, but that can only be changed by additions to the
syntax and/or API so it won't help you now.

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk10Hy0ACgkQmOOfHg372QTjcgCgsMtIeZEP+fgUzTrTvolidvLj
+kcAnjR/PoN/Fm5AKT1uO7zzpCq93A6F
=+H9P
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to