All Questions
4
questions
7
votes
1answer
386 views
How many disk seeks does it take to write one row on SQLite?
As far as I understand, there can be one disk-seek per rotation of a harddisk, therefore I am interested to know how many disk seeks are needed for writing a row to an SQLite table, including locking ...
6
votes
3answers
6k views
SQLite CSV import won't create a table automatically
According to https://www.sqlite.org/cli.html#csv,
sqlite> .mode csv
sqlite> .import C:/work/somedata.csv tab1
There are two cases to consider: (1) Table "tab1" does not previously
exist ...
5
votes
2answers
3k views
Directly import a csv gzip'ed file into SQLite 3
I'd like to import a 15GB file comma delimited gzip compressed file into Sqlite 3 without having to use temporary files.
I'd like to run a command like:
zcat input/surgical_code.csv.gz | tail -n +...
1
vote
0answers
17k views
how to import .xls file into SQLite database?
I have an issue with importing .xls file into SQLite database. I am working on windows xp and using a SQLite manager for maintain the database. I can import the .csv file to the database by using ...