-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

geeta varu wrote:
when i'm trying run a query which is having some
27k records always i get error OutOfMemoryError...
any reasons..

What client are you using? JDBC? If so, you need to give more memory to your JVM with the '-xMX' flag, because the JDBC driver needs to hold the entire result set in memory, unless you use 'streaming' result sets, which are covered in the README that comes with the driver.


-Mark


- -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/


For technical support contracts, visit https://order.mysql.com/?ref=mmma

    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
        <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD4DBQE+XMt8tvXNTca6JD8RAsK7AJ9Pj+gV8Vb4E4duim/Tos85wF2OOQCY0dsd
Ljhcv707Qsg/6rRmnMmbGg==
=QnXU
-----END PGP SIGNATURE-----


--------------------------------------------------------------------- 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



Reply via email to