|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 26th, 2005, 05:13 PM
|
|||
|
|||
|
Extremely Slow Connection
Huge problem. I went to overlay a database after I made some conversions and now every time I run the app, it is extremely slow when connecting to the db. When I run locally the app runs perfectly. Nothing wrong with the db file. I've reinstalled the firebird server, changed ip addresses, tried to use a different hosting computer. Nothing. I've even resorted to backups over a month old for both the db and the app and still it runs extremely slow.
I'm getting desperate here. Has anyone else run into a problem with their .Net apps taking forever when connecting to a database on a server?? I reinstalled both as classic and super server and even took Guardian down. Please help.
|
|
#2
May 27th, 2005, 01:28 AM
|
||||
|
||||
|
Well, it seems that you've tested the db/hosting server/app problems out ... all that remains is the connection between the computer and the server.
Don't have any experience with .Net though so can't help you there. You could try placing the app on another comp and keep the hosting server the same also. (maybe there is a problem with the computer you are testing on - virus/trojan etc)
__________________
If i've been helpful, please add to my reputation. My unfinished site: http://www.dever.ro
|
|
#3
May 27th, 2005, 03:05 AM
|
||||
|
||||
|
It could be a DNS related problem (slow DNS name lookup) if you are connecting to a remote host.
Hope this helps.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#4
May 27th, 2005, 03:22 AM
|
|||
|
|||
|
Quote:
That was my thinking, too... -- Best regards, Fikret Hasovic http://fikret.fbtalk.net USAID TAMP Senior Programmer * FirebirdSQL Foundation member. - Join today at http://www.firebirdsql.org/ff/foundation * JEDI VCS contributor http://jedivcs.sourceforge.net/ * Firebird and Fyracle news http://www.fyracle.org
|
|
#5
May 27th, 2005, 01:22 PM
|
|||
|
|||
|
Appreciative of the assistance. It was a network issue in which the port was being blocked. Guess they noticed large amounts of data going through and blocked the port.
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Extremely Slow Connection |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
