200 000 records in the DB all at once - Joomla! Forum - community, help and support

hello!

i have create 200 000 pages 1 site. know have take account _asset tables in relation creating _content records. there set of mysql scripts using can create these 200k articles @ once. me giving me tips or writing script can go on project.

so far created 25k records using "copy" option in batch command. have hit maximum length of php.ini max_execution_time run errors 500.

there must way write mysql command line records created @ once while respecting _asset table requirement. me out request?

all need @ point create _content entry goes along _asset requirements. need title (i use digits) , alias (the-same-digit). rest of record xxx in _content table, use openoffice calc edit , fill in blank fields , write update mysql command need.

yours,

marc
montreal, canada.

what business objective trying achieve?
why need 200 000 pages?
where data go pages?
do have once or performance important?
can explain _asset tables?
what "copy" using?
can change php.ini max_execution_time?
please post example sql statement(s).

regards

geoff