Re: [sqlite] Performance in a case of big columns number

2009-09-19 Thread Dmitry Konishchev
Thanks! I hope that it will work faster. If you have any links to articles describing such dark sides of SQLite or some techniques of using it such as this, I'll be very grateful if you write them here. Pavel Ivanov wrote: > Yes, you will be able to find information you need. You can store your

Re: [sqlite] Performance in a case of big columns number

2009-09-19 Thread Dmitry Konishchev
Please sorry for my terrible Engilsh. :) Thanks for the answer. Yes, I know that it is bad design in the common case. But I have to use it because I have data which has following format: time | value_1 | value_2|value_ |---|-|

[sqlite] Performance in a case of big columns number

2009-09-17 Thread Dmitry Konishchev
Hello. Data in my program has such format that there is useful to place it in the database in many (thousands) columns. Please, answer me: does SQLite work more slowly when it has very big number of columns in the table (with the same total amount of data)?