Can you give a (short) example of some lines, and how you import them? Creating a table with 1 field text 255 seems not the right way to do this if you are only interested in emailaddresses.
On 22-12-17 01:22, Lawrence Murphy wrote: > I am supporting a website which aims to protect a forest from development. > The website produces an email for supporters to mail out. A copy of the > email is sent to our Gmail address and we wish to capture the supporters > return email address. Google provides an archive of our Gmail account which > is 458Mbs in size and contains a lot of superfluous data. > > I have tried making a table with one column, text 255c in size and doing > the import but it takes more than overnight and is still running. Is there > a quicker way to import the data? > > Warm Regards, > Lawrence > > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users