Hi, My application uses SQLite as its file format and up to two of the tables can have several thousand columns (up to 20 or 30 thousand at times).
When I open a connection there's a noticeable pause (around one second on a file with a table of 7,000 columns, for example). There is also a noticeable delay in sorting them by the primary key. Is there anything I can do to favour this kind of tables? I am using the version 3 dll and accessing it through C++. If it improves performance I can go all the way and compile SQLite myself. Thanks Jose http://www.GenXproTools.com/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
