fast retrieval of millions of record
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.
Regards
Akasmika
Subject
Views
Written By
Posted
fast retrieval of millions of record
11452
November 16, 2005 05:54AM
6665
April 24, 2008 08:56AM
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.