|
Home > Archive > MySQL ODBC Connector > January 2006 > Setting SQL_BIG_SELECTS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Setting SQL_BIG_SELECTS
|
|
| David P. Donahue 2006-01-26, 4:56 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 need to put in the connection string? Something I need to
put in each query? Basically, is there a way to set it globally on the
MySQL server so it will apply to all sessions/connections?
Regards,
David P. Donahue
ddonahue@ccs.neu.edu
http://www.cyber0ne.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| SGreen@unimin.com 2006-01-26, 4:56 pm |
| --=_alternative 0069C3D285257102_=
Content-Type: text/plain; charset="US-ASCII"
"David P. Donahue" <ddonahue@ccs.neu.edu> 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 need to put in the connection string? Something I need to
> put in each query? Basically, is there a way to set it globally on the
> MySQL server so it will apply to all sessions/connections?
>
>
> Regards,
> David P. Donahue
> ddonahue@ccs.neu.edu
> http://www.cyber0ne.com
>
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?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 0069C3D285257102_=--
| |
| David P. Donahue 2006-01-26, 4:56 pm |
| > 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 class uses the MySQLConnector .NET
library (1.0.7) to issue SELECT statements to populate DataSets. The
connection string is as follows:
" Uid=myUsername;Pwd=m
yPassword;Server=192
.168.0. 12;Database=myDataba
se;"
The function which returns the results of the query boils down to the
following:
mySqlConnection = new MySqlConnection(stri
ngDatabaseConnection
);
mySqlDataAdapter = new MySqlDataAdapter(str
ingSelect, mySqlConnection);
dataSetSQL = new DataSet();
mySqlDataAdapter.Fill(dataSetSQL);
return dataSetSQL;
Regards,
David P. Donahue
ddonahue@ccs.neu.edu
http://www.cyber0ne.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|