PHP, MySQL performance
I have 2 tables PHP, MySQL (table1 = 10 columns, table2 = 15 columns).

Table1 is filled by CSV import, normally 10,000 records.

Once CSV is imported successfully, I  need to grab the 10 columns from table 1, do some calculations, interact with other db tables and fill the extra 5 columns in Table 2, and delet table1 content.

I concern about large number of number data, memory limits, timeout, etc. 

Is there any PHP or Mysql built in function to improve the performance? I have problem using buffers with SQl SELECT and sleep() is no use. Any other built in function?

It was also suggested to use ajax and setintervals() to walk through data in small chunks? Is this OK?


PHP, MySQL performance
===

I have 2 tables PHP, MySQL (table1 = 10 columns, table2 = 15 columns).

Table1 is filled by CSV import, normally 10,000 records.

Once CSV is imported successfully, I  need to grab the 10 columns from table 1, do some calculations, interact with other db tables and fill the extra 5 columns in Table 2, and delet table1 content.

I concern about large number of number data, memory limits, timeout, etc. 

Is there any PHP or Mysql built in function to improve the performance? I have problem using buffers with SQl SELECT and sleep() is no use. Any other built in function?

It was also suggested to use ajax and setintervals() to walk through data in small chunks? Is this OK?

