On Jan 5, 2007, at 6:54 AM, jbv wrote:
Hi list,
For some reasons too long to explain here, I need to dump
large amounts of data from a mySQL table to a txt file (for instance
15 columns for 35000 records that represents about 1.5 Mb).
I'm using Rev cgi 2.5 and mySQL 3.23.
I use revDataFromQuery which happens to be VERY slow
(about 20 sec to get 1.5 Mb of data from mySQL)...
I was wondering if there was any way to speed up such data
transfer between mySQL and Rev cgi, or may be to send to
mySQL (may be via the shell) an SQL request to dump the
content of some columns of a table into a txt file that could be
opened later from Rev cgi...
Any help on this domain would be greatly apreciated...
You can use a standard SELECT statement, but just add this:
INTO OUTFILE <filePath>
Note that this dumps the file to the server host, not the client, so
you'll need to have the FILE privilege assigned to the logged-in user
to be able to execute it. This writes it out tab-delimited, with
tabs, newlines, or "\" that occur in field values escaped with a
preceding "\".
If you want the file generated on the client, then you'll have to do
a SELECT and put that into a Rev variable, then output the data from
the variable to the text file.
HTH,
Ken Ray
Sons of Thunder Software, Inc.
Web Site: http://www.sonsothunder.com/
Email: [EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
