Latest SQLite version with the VB wrapper from Olaf Schmidt, dhRichClient.dll. Running this in VBA Excel on Windows XP.
Have a suspicion that maybe you could get slow queries if a table repeatedly gets a DELETE FROM TABLE followed by re-populating the table with inserts, so cyling this repeatedly. It is the delete query that gets slow. No logical explanation and no idea yet what exactly happens, but definitely something strange going on. Maybe it somehow has to do with my application or maybe the wrapper, but these are simple queries and there and the data is all simple and nothing unusual there. I have dealt with this now by dropping the table once in every Excel session and this seems to do the trick. Is there anything in the SQLite code that could make this happen or should I look at my app or the wrapper? Thanks for any advice. RBS ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
