> 1) need to know if sqlite can help me cut down on the number of little db's
Sure. > 2) can I use it for a message store and have it run faster than a 1 > message per file system? What does that mean? Is "file system" a unit of time? You can store messages in BLOBs or as TEXT in an SQLite table. > 3) how would one allocate the different data sets across how many dbms? You can put all your data in a single sqlite database file, or use several different sqlite database files and ATTACH them at runtime - it's up to you. If you're new to SQL, here's a good link: http://sqlzoo.net/ ____________________________________________________________________________________ Yahoo! Music Unlimited Access over 1 million songs. http://music.yahoo.com/unlimited ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------