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
> 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 [value_
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_
|---|-|
[time
> 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
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_
|---|-|
[time_1]
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 7
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 in the table
> (with th
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)?
_
8 matches
Mail list logo