Loading data from database to Excel takes lot of time.How to Minimize it?

[selvialagar]

Hi Everybody..

I have lot of data stored in the database depending upon the time the experiment conducted. Once th experiment is completed, i have to store that data into the excel.

When doing (loading data from database and write into excel) that, takes lot of time and CPU memory usage will be above 70%. Can i control it? or can I minimize the time consumption? or Is there any better way to perform the opertion?

[r035198x]

Which database are you using? You could export to cvs directly from the database using some export/dump command depending on your database.

[selvialagar]

Which database are you using? You could export to cvs directly from the database using some export/dump command depending on your database.

I'm using database in mysql. I don't know about cvs. How to load data to cvs?
please can u explain it?

[r035198x]

I'm using database in mysql. I don't know about cvs. How to load data to cvs?
please can u explain it?

Check the MySQL refmanual for the SELECT INTO OUTFILE command.