Hello,
IF you create index Primary key it automatically index the Information, but
if not you can always create a separate index for your field(s). When Index
are present at time of insertion or update index will also get update to
include information. That do not REindex complete table. So
Hello,
Do you truncate the table before iterating again ?
I don't think it really effect performance, if you start from 1 or 1001.
They are just number. You don't need to re-index your table. Indexes are
created automatically at time of insertion/update/delete. So even if you
delete old
Hello,
IF you need to do that just to setup your database once, then you can use
any of free tools as suggested. Or you can simply run a SQLCommand through
your code to drop and recreate a table using Standard SQL Create Table
statement. Alter query will work to drop and add column as well.
Dataset object in
.NET to do bulk upload. I use that Dataset method to upload about 70,000
records in to SQL server and it take 10-15 sec, but in Sqlite it is still
taking minutes to record that data.
Any idea how I can speed this up.
With Regards,
Sumit Gupta
Dataset object in
.NET to do bulk upload. I use that Dataset method to upload about 70,000
records in to SQL server and it take 10-15 sec, but in Sqlite it is still
taking minutes to record that data.
Any idea how I can speed this up.
With Regards,
Sumit Gupta
Subject: Re: [sqlite] Bulk Insert
On Fri, Aug 12, 2011 at 2:09 PM, Sumit Gupta gamersu...@gmail.com wrote:
query is only reading about 400-500 record per minute. This way it is
going
If you are not currently using a transaction to wrap the whole import, add a
transaction and the speed will improve
my read
Binary Loop in Sqlite transaction only.
Any guidance is great. Looks like Sqlite finally solve my problem thus far
:).
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
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Bulk Insert
On 08/12/2011 14:25, Sumit Gupta wrote:
Hello,
Thanks for your suggestion, yup the Speed with Transaction is increase
multifold. In 5 minute it read half the data. But wondering what different
the Transaction make as compare
Well, I am not an expert on this, but just want to touch some base things
1. Did you set indexes ? Sometime conversion tools didn't do that stuff
properly.
2. Is Sql Server reside on same desktop or on LAN ? if it is on LAN probably
the server machine is better and hence the comparison is
. Our XML method take
about 1 GB Storage on harddisk for data, mainly due to overhead of XML
itself. I am eying to have Harddisk usage of about 300-400MB with use of
SQLite if possible.
With Regards,
Sumit Gupta
___
sqlite-users mailing list
sqlite-users
in great speed so I am not worried there.
Just that I need to organize application data better.
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 17:54
To: General
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: [sqlite] SQLite with 10M record
12 matches
Mail list logo