On Wed, Aug 20, 2008 at 6:03 AM, cstrader <[EMAIL PROTECTED]> wrote:
> Well it turns out that the db created this way (including the index) is no
> smaller than the one with 2400 tables, and the read is no faster! Does that
> make any sense?
Do you often pull your data one stock at a time? If so
have only 1 row per day, if you have more than 1 you'll
need to add additional where clause fields or do a Max, min etc.
--- On Wed, 8/20/08, cstrader <[EMAIL PROTECTED]> wrote:
From: cstrader <[EMAIL PROTECTED]>
Subject: Re: [sqlite] 2 Questions from a newbie
To: "General Dis
;; "General Discussion of SQLite Database"
<sqlite-users@sqlite.org>
Sent: Tuesday, August 19, 2008 12:51 PM
Subject: Re: [sqlite] 2 Questions from a newbie
> If all 2,400 tables have the same 9 columns you could try using a
> single table and adding a column for the
cstrader wrote:
> OK, this seems really helpful, but I'm afraid you've lost me a bit.
>
> 1. Third normal??? :)
See http://en.wikipedia.org/wiki/Third_normal_form for an explanation.
>
> 2. Your idea would be to have one table that's relatively static, with the
> names (and perhaps other
CTED]
[mailto:[EMAIL PROTECTED] Behalf Of cstrader
Sent: Tuesday, August 19, 2008 12:24 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] 2 Questions from a newbie
OK, this seems really helpful, but I'm afraid you've lost me a bit.
1. Third normal??? :)
2. Your idea wou
nal Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of cstrader
> Sent: Tuesday, August 19, 2008 11:53 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] 2 Questions from a newbie
>
>
> OK, cool idea... let me try that.
>
sday, August 19, 2008 11:53 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] 2 Questions from a newbie
OK, cool idea... let me try that.
- Original Message -
From: "Jeff Hamilton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "General Discussion of
?
- Original Message -
From: "Greg Morphis" <[EMAIL PROTECTED]>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Sent: Tuesday, August 19, 2008 1:01 PM
Subject: Re: [sqlite] 2 Questions from a newbie
> Also why are you adding new c
t;[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; "General Discussion of SQLite Database"
> <sqlite-users@sqlite.org>
> Sent: Tuesday, August 19, 2008 12:51 PM
> Subject: Re: [sqlite] 2 Questions from a newbie
>
>
>> If all 2,400 tables have the same
OK, cool idea... let me try that.
- Original Message -
From: "Jeff Hamilton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "General Discussion of SQLite Database"
<sqlite-users@sqlite.org>
Sent: Tuesday, August 19, 2008 12:51 PM
Subject: Re: [sqlite
If all 2,400 tables have the same 9 columns you could try using a
single table and adding a column for the ticker of the stock and then
add an index to that column to allow quick lookups based on the
ticker.
-Jeff
On Tue, Aug 19, 2008 at 9:44 AM, .:UgumugU:. <[EMAIL PROTECTED]> wrote:
> Hi
Hi cstrader,
Just send some table structure and the explain what you are trying todo.
In my opinion it is not a good way to deal with 2400 tables :)
ugumugu
cstrader yazm?s,:
> I'm just starting with SQLite (from vb.net) and could use some advice.
>
> I have a set of 2400 (could get
I'm just starting with SQLite (from vb.net) and could use some advice.
I have a set of 2400 (could get substantially higher) tables in a single
database (each table contains daily stock prices for a different stock).
Each table has 9 columns (all text for now) and some several thousand rows.
So
13 matches
Mail list logo