Jeff Picciotti wrote: > I know it would be simple to separate the column out and create a > :memory db, but that would require numerous changes to our system > (easily doable, just not at the moment) So I was just checking the > community to see if anyone has any ideas or thoughts on this! >
Jeff, You might be able to do this easier if you use a temporary table to hold the transient data. The temp table could be joined with a permanent table in a view that would replace the existing table. All your existing queries would work the same as before (I think, there may be issues with column naming, but that can be fixed by setting aliases for all the result columns in the view that match the existing table's column names). You would then have to add a set of "instead of" triggers to handle inserts, updates, and deletes from the view. HTH Dennis Cote _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
