Setting SQL_BIG_SELECTS

2006-01-26 Thread David P. Donahue
I've determined that I need to set SQL_BIG_SELECTS=1 for an application I have which connects to a MySQL 4.x database. However, I don't see how to apply it universally to that application's connection. Is it something I need to put in the connection string? Something I need to put in each

Re: Setting SQL_BIG_SELECTS

2006-01-26 Thread SGreen
David P. Donahue [EMAIL PROTECTED] wrote on 01/26/2006 02:19:25 PM: I've determined that I need to set SQL_BIG_SELECTS=1 for an application I have which connects to a MySQL 4.x database. However, I don't see how to apply it universally to that application's connection. Is it something I

Re: Setting SQL_BIG_SELECTS

2006-01-26 Thread David P. Donahue
How to specify that option depends entirely on how you are forming your connection with the MySQL server. Which connection library are you using and how are you opening your connection? The application is an ASP .NET web app hosted on Mono on an Apache web server running Linux. My data

Re: Setting SQL_BIG_SELECTS=1 for MySQL server

2004-02-26 Thread Egor Egorov
Jennifer Horne [EMAIL PROTECTED] wrote: We've recently started using MySQL for customers with a large number of records on their systems. For the first time, one of our customers has gone over the 4 million record mark, and we're running into some problems with the MAX_JOIN_SIZE and the

Setting SQL_BIG_SELECTS=1 for MySQL server

2004-02-25 Thread Jennifer Horne
We've recently started using MySQL for customers with a large number of records on their systems. For the first time, one of our customers has gone over the 4 million record mark, and we're running into some problems with the MAX_JOIN_SIZE and the SQL_BIG_SELECTS. Using the control center, or