spyrit
05-30-2006, 09:31 AM
Hy there guys, i have a proble, hope you can help me.
I have a webpage asp.net, in the aspx.cs i make a mysql connexion and i oppen it. the connexion is to a database that is located on a remote machine running linux. The problem is that the connexion.Open() is taking too much time, aroun 25 seconds each time. And i open it and close it in a few controls i use on the page, nd each time i have to wait a long time. The question is: is there a way to make the connexion persistant? I mean to open it only once at the beginning and close it at the end?? Or is there a way to speed up the open proccess so it won't take this much time??
Thx for your help.
I have a webpage asp.net, in the aspx.cs i make a mysql connexion and i oppen it. the connexion is to a database that is located on a remote machine running linux. The problem is that the connexion.Open() is taking too much time, aroun 25 seconds each time. And i open it and close it in a few controls i use on the page, nd each time i have to wait a long time. The question is: is there a way to make the connexion persistant? I mean to open it only once at the beginning and close it at the end?? Or is there a way to speed up the open proccess so it won't take this much time??
Thx for your help.