]
Sent: Thursday, September 14, 2006 4:42 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Very wide tables and performance
Hi Dennis,
This is an OLAP product and indeed we don't know upfront how much of
that data is relevant to the processing. I had a normalized group of
tables for those
d probably not only me) am very excited to see definition
for this table ;)
WBR, Denis
-Original Message-
From: jose simas [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 13, 2006 11:05 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Very wide tables and performance
Thanks for you
databases.
Anyway, I (and probably not only me) am very excited to see definition
for this table ;)
WBR, Denis
-Original Message-
From: jose simas [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 13, 2006 11:05 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Very wide tables and
Thanks for your answers! I am very happy with SQLite as it is I was
just wondering if I could improve it for this case.
I am using tables with this configuration for performance reasons. I
have to support an indeterminate number of columns (user data) and a
"normal" design is not as fast as this
jose simas wrote:
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
"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
6 matches
Mail list logo
