Hi - This is related to my last message. I'm trying to figure out how to do something and maybe someone else has already figured this out.
I'm using the same code with both SQLite and MySQL by having separate implementations of the database primitives. I have already written lots of queries that JOIN tables from multiple databases using the MySQL syntax of database.table, and I'd like to be able to do the same with SQLite. It looks like the way to do this is to use ATTACH DATABASE. However, for performance reasons, I've enclosed all the queries in large BEGIN TRANSACTION / COMMIT TRANSACTION blocks (these do nothing in the MySQL implementation). Since you can't do an ATTACH DATABASE inside a transaction, I think I have these options: 1. Make the restriction that all the ATTACHes have to be done outside the transactions. 2. Put the tables all in the same database for SQLite. 3. At the point the cross-database JOIN is needed, force an COMMIT TRANSACTION, then do the ATTACH DATABASE, then do another BEGIN TRANSACTION. These all have varying drawbacks. Has anyone solved this problem a different, better, way? Thanks! Allan Miller ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
