I have a somewhat large table in an sqlite database and another large table on an MS SQL Server database (on a slow network). I want to query both tables in a join.
The join is likely to produce from zero to a dozen rows. First thought was to copy the data from the SQL Server table to the sqlite file, but that alone takes over 4 minutes to run. What I am currently doing is to copy the data from the sqlite table to an MS Access table, then have Access link to SQL Server, and run the query in Access. The copy takes just under a minute, and the join also takes just under a minute. So a total under 2 minutes. Twice as fast! But, I want to move this to a different computer which does not have an MS Access license, and corporate IT doesn't want to pay for that license. So what other options do I have? I haven't been able to find anything to say how I could use ODBC to connect to two different data sources. I haven't seen how I could ATTACH to an ODBC link within sqlite. (I would guess a vfs could be written to do that, but if even feasible that is far beyond my minimal coding skills.) Thanks for any suggestions you can give. David _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
