Hi all,
I have a flat file with pipe seperated data which needs to be inserted into
a sqlite table.
I have written a script for the same and it also works.
But my problem is that the flat file has 46000 records due to which the data
insertion process is becoming very slow.
Can anyone suggest me
I am assuming you are using separate INSERT statements in your script. You
can either try to use the COPY or .IMPORT commands (depending on the version
of SQLite you are using), or combine the INSERT statements into a single
transaction using BEGIN and COMMIT.
Regards
Hans
Dear DRH,
I am using Sqlite in a Microsoft Windows environment with DevCpp + MinGW (a
GCC porting). I lack the UNIX build
facilities so I find very helpful the availability of a zip source archive
in which all the preprocessing is alredy done.
Now I can observe a lot of check-ins since the
A few problems with SQLite3Explorer 1.5:
Further to these, I've found that viewing of text data in the grid is
limited to 255 characters. Is it possible to make the default a lot bigger
or have a way of zooming a field to get the final value.
Hugh
Ticket:
http://www.sqlite.org/cvstrac/tktview?tn=1224
Contains an updated patch to remove config.h as a requirement for SQLite
source. This allows the cross-compile between platforms of different
pointer size (eg. 32bit-64bit) which is not possible with the current
config.h solution.
If anyone