Re: [Q] INSERT INTO ... SELECT
Riaan Oberholzer <[EMAIL PROTECTED]> wrote: > Is there a limit on the number of rows that can be > inserted in this way? Ie, at what point should I start > worrying about "out of memory" errors or something > similar? > > So, how many rows can/should be returned by the SELECT clause? There is no limitation in MySQL. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [Q] INSERT INTO ... SELECT
Hello Riaan, RO> Is there a limit on the number of rows that can be RO> inserted in this way? Ie, at what point should I start RO> worrying about "out of memory" errors or something RO> similar? RO> So, how many rows can/should be returned by the SELECT clause? I had a similar case. Difference is that I tried to read result in the array and then to work from it. Hoever ... I think that the problem is in your RAM and OS. In my case I can read in memory succes up to 3 mil records. When I tried more I received Out Of Memory, too. I looked at windos swap file and it was more than 2GB Hoever, in my case I found desicion to read and insert data record by record. Slowly, but success. -- Best regards, Krasimir_Slaveykov, 03 Ôåâðóàðè 2004 ã., 15:49:27 mailto: [EMAIL PROTECTED] [EMAIL PROTECTED] |-| |/ * * *** * ** /| | *** *** *** *** *** *** ** *** //| |/// *** *** * * *** **** *** ///| |// *** *** *** *** *** *** ** ****** | |/ *** *** *** * *** /| |--- www.office1.bg --| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Q] INSERT INTO ... SELECT
Is there a limit on the number of rows that can be inserted in this way? Ie, at what point should I start worrying about "out of memory" errors or something similar? So, how many rows can/should be returned by the SELECT clause? __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
