to me, at least worth a try on couple of days
efforts.
With Regards,
Sumit Gupta
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS)
Sent: 11 August 2011 18:58
To: General Discussion of SQLite Database
Subject: Re: [
ite-users-boun...@sqlite.org] on
behalf of Sumit Gupta [gamersu...@gmail.com]
Sent: Thursday, August 11, 2011 7:28 AM
To: 'General Discussion of SQLite Database'
Subject: EXT :Re: [sqlite] SQLite with 10M record
Hello,
I have Experience with SQL Server and MySql, but not with SQLite.
2011/8/11 Sumit Gupta :
> 10-10-2011 18:48:42, 10,20, 30, 40, 50, 60, 80 .. <48 such entries>
Use unixtime (time in seconds) and index on this field and your
queries will be fast.
You can use single blob as integers array for more compact database.
--
Best regards, Alexey Pechnikov.
http://pechn
:54
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite with 10M record
Have you ever used SQLite before? 10M records is not a big deal.
With experience it should take you less than hour to prove this one way or
the other. But that depends on you having experience with databases
(i
Have you ever used SQLite before? 10M records is not a big deal.
With experience it should take you less than hour to prove this one way or the
other. But that depends on you having experience with databases (indexes) and
SQLite in particular (WAL mode, exclusive locking, etc). Without expe
5 matches
Mail list logo
