List:General Discussion« Previous MessageNext Message »
From:Rodney Broom Date:September 14 2001 1:42am
Subject:Re: uploading 200,000 x 5 rows
View as plain text  
Hi Carlos,

I'm glad to help, but I'd like to clarify several things, first.


> ...with about 200,000 data about books
> (title, clasif, year, publisher, authors, subjects, etc etc)

So you have a single file with data for multiple tables?


>   After each sequential parsing (one book)

What defines one book? One file, several records from one or more files, or one record
from a single file?


> i upload that info to the database

You "upload"? How is this done, exactly? Do you mean that you run mysql from one machine
with the host set for another machine?


> ...but in 5 tables...

So you've split your data into sets that need to get loaded into five destination tables,
or you upload five sets of data?


> (verifying duplication, ids, etc):

Does this mean that you are checking for  duplicates before loading into MySQL?



---
Rodney Broom
Programmer: Desert.Net



Thread
uploading 200,000 x 5 rowsCarlos Proal14 Sep
Re: uploading 200,000 x 5 rowsRodney Broom14 Sep
Re: uploading 200,000 x 5 rowsCarlos Proal14 Sep
Re: uploading 200,000 x 5 rowsCarlos Proal14 Sep