"jose simas" <[EMAIL PROTECTED]> wrote: > > 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. >
While there is no limit to the number of columns in an SQLite table (other than the ability of a 32-bit integer to count them) there are a number of places in the parser where performance is quadratic in the number of columns in the table. These places could be rewritten to work in expected linear time, but I made a deliberate design decision to keep the code simple and fast for the very common case of a reasonable number of table columns. Your solution, of course, it to refactor your design to use tables with fewer columns. Not only will this help SQLite to run much faster, it will also likely make your program easier to read and maintain. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
