MySQL Forums
Forum List  »  Archive Storage Engine

fast retrieval of millions of record
Posted by: Akasmika Dash
Date: November 16, 2005 05:54AM

Dear All,

I'm working for the summary log which will generate a log file from MySQL database.
For putting into file I've written SELECT * ..... INTO OUTFILE appp.csv FROM ...

For summary log, I've to do a JOIN from 8 tables.

I've made proper indices in the tables.

Now for some 4 lakhs records, it's taking 1 minute. I want to make it faster as it will be placed in real network.

Can I make the log creation faster as I have to deal with millions of recors.

Thanks in advance.


Options: ReplyQuote

Written By
fast retrieval of millions of record
November 16, 2005 05:54AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.