Hi, I use the mm.mysql-2.0.6 jdbc driver and have some performance problems. SELECT ... INTO OUTFILE ... and SELECT LOAD_FILE()... are much faster than fetching all rows via the JDBC API. I would like to implement a similar solution that all results are returned in a single string. Unfortunately I cannot use the solution described above because the SELECT INTO OUTFILE works only (as far as I know) when the output file does not exist and when the client and server hosts are not the same I cannot delete the output file.
Zsolt -- Zsolt Koppany Intland GmbH www.intland.com Schulze-Delitzsch-Str. 16 70565 Stuttgart ____________________________________________________ Berufsunfähigskeitversicherung von Mamax bei WEB.DE. Jetzt informieren! http://bu.web.de --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
