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

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

> Unfortunately I can't use such design because in this case I will not > able to find in the database such data as I need Yes, you will be able to find information you need. You can store your data like this: time | val_num | value | |---|---| [time_1] 1

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

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_ |---|-|

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

> It'll work, but SQLite does not use a balanced tree to store the > columns for a particular record. So if you're seeking the 700th > column of a particular row, it has to look through 699 others before > it gets to it. Unless you always handle all the columns of a row > together, it'll

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

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_ |---|-|

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

On 16 Sep 2009, at 3:23pm, Dmitry Konishchev wrote: > Data in my program has such format that there is useful to place it in > the database in many (thousands) columns. It'll work, but SQLite does not use a balanced tree to store the columns for a particular record. So if you're seeking the

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

On Wed, Sep 16, 2009 at 9:23 AM, Dmitry Konishchev wrote: > 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

[sqlite] Performance in a case of big columns number

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)?