On Dec 30, 2008, at 1:29 AM, schachtobi wrote:
>
>> Date: Mon, 29 Dec 2008 11:20:58 +0700
>> From: Dan
>> Subject: Re: [sqlite] sqlite3_get_table question
>> To: General Discussion of SQLite Database
>> Message-ID: <65fa0cc6-4248-4675-8100-f069423e0...@gmail.com
>
>
>> Why (ncol+2)?
>
>
> I mak
>> I am sure there is a better way to deal with 12K rows by 2500 columns,
>> but I can't figure it out
>
> 2500 columns sounds like a nightmare to deal with
>
> could you perhaps explain that data layout a little?
It is a download of a huge longitudinal survey
(www.bls.gov/nls/nlsy79.htm) that
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rachmat Febfauza
Sent: Sunday, December 28, 2008 9:13 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] confusing with how to to this in sqlite
thanks simon fo
> Date: Mon, 29 Dec 2008 11:20:58 +0700
> From: Dan
> Subject: Re: [sqlite] sqlite3_get_table question
> To: General Discussion of SQLite Database
> Message-ID: <65fa0cc6-4248-4675-8100-f069423e0...@gmail.com
> Why (ncol+2)?
I make the following select statement:
SELECT fname, dsize, data,
Hello!
I did find interesting article about this popular question
http://blog.maxindelicato.com/2008/12/how-to-organize-a-database-tables-keys-for-scalability.html
I would also like to add that SQLite supports "attach" command due to which we
are able to use a
lot of database shards on a singl
On Sun, Dec 28, 2008 at 11:49:34PM -0800, Webb Sprague wrote:
> I am sure there is a better way to deal with 12K rows by 2500 columns,
> but I can't figure it out
2500 columns sounds like a nightmare to deal with
could you perhaps explain that data layout a little?
__
6 matches
Mail list logo
