Hi Garry, can you show me with code how You are inserting with maintaining 1st row as to make header of table ,and next other inserting fastest way into db... please show me your code view for that. little bit i m confuse over its inserting process into db directly into db. mine still its slow.... please help me on this .
Regards, Alok On 3 January 2011 22:46, GS <[email protected]> wrote: > Simon Slavin wrote : > > Also you are still using a 2D array to store your values. This is slow > and > > requires a lot of memory. Instead, use one array to read in the first > row > > (with the names of the columns) and then use a second 1D array for each > row > > of values: read one line in then write the row out, then read the next > line > > in. You should not need any 2D arrays in your code at all, and you will > > never hold the full file content in memory all at the same time. > > <FWIW> > Would this be worthwhile? > > I use a 1D array to hold delimited file data, wherein the first element > (0) contains the column headings. This allows me to start the records > at element (1) so the UBound of the array is the number of records. I > find this convenient for setting up the column headings before looping > through the records (1 To UBound). > > -- > Garry > > Free usenet access at http://www.eternal-september.org > ClassicVB Users Regroup! comp.lang.basic.visual.misc > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Thanks Alok Kumar Singh _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
