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 access

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

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 qu

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

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 c