Hi Donald,
1. Size of the SQLite Database : 43 MB.
2. Number of tables : 45
3. Maximum number of rows in a table is around 75,000
We initially tried with few tables and it was not always successful but after
we got to 45 tables,
we did not use SQLite ODBC driver at all.
Rght now, I am using SQL Maestro Data Wizard. This tool has a feature to
automate data import using templates
but since we have exceed the ini file limitation of 64 KB, I have to run it
using the wizard each time not automation.
Right now, using the Data Wizard tool, it takes like 30 minutes to import all
the data.
Thanks
Baskaran
> Date: Wed, 12 Nov 2008 11:46:16 -0500> From: [EMAIL PROTECTED]> To:
> sqlite-users@sqlite.org> Subject: Re: [sqlite] SQLite Import Tool> >
> Greetings, Baskaran,> > Regarding: "SQLite ODBC driver takes hours for data
> transfer and most of> the time it is not success."> > > Rather than folks on
> the list providing method after method, it might be> helpful for you to give
> some further information, such as:> > -- Just approximately, how much data
> are you converting regularly.> I.e., how many megabytes , tables, and rows
> are involved?> > > -- You mention that you are now doing this "manually".
> Could you> elaborate? Does this mean you're dumping the data to some text
> format,> then importing into sqlite with, perhaps the sqlite3.exe>
> command-line-tool? If so, might simply adding a batch script to this> process
> give you the automation you need? > > -- How long does the manual conversion
> take to run? > > -- Have you determined which of your tables is giving you
> the problem?> How far into your conversion are you getting?> >
> _______________________________________________> sqlite-users mailing list>
> sqlite-users@sqlite.org>
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_________________________________________________________________
See how Windows® connects the people, information, and fun that are part of
your life
http://clk.atdmt.com/MRT/go/119463819/direct/01/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
