We run a few VPS servers here and have found them good for testing but not so in a production environment. Reason is that if any other VPS on your physical server runs a process that eats up any resources (HD, net, etc) then it could make your VPS completely unaccessible. I would recommend you get a some dedicated or managed MS SQL backend environment to support your application.
Tim Marselle wrote: > > Chris.. I totally agree... perhaps you may want to send him a small > example here on how to set a nTier environment.. also is MySQL lic > cost very much...? you may want to add some pro's and cons about that > as well > > --- On Thu, 5/1/08, Chris <[EMAIL PROTECTED] > <mailto:jangita%40jangita.com>> wrote: > From: Chris <[EMAIL PROTECTED] <mailto:jangita%40jangita.com>> > Subject: RE: [delphi-en] Mssql Locking causes Delphi App to crash > To: [email protected] <mailto:delphi-en%40yahoogroups.com> > Date: Thursday, May 1, 2008, 7:58 AM > > Hi, > > I have been through the same thing; sadly to say the only way I solved it > > was to change my database backend to mysql from mssql; My Delphi > application > > is currently running in 700 locations countrywide; so the database > server is > > hit with about 5 requests per second with over 14,000 simultaneous > > connections and its all _smooth_. > > Your case seems to be that you are connecting MSSQL clients via a wan > > connection which I can guess is not as fast as a LAN connection; I don't > > think the problem is the database backend or Delphi; its mysql. Not a > > problem per-say; its just that MSSQL protocol over a network is > "chatty" and > > is quite heavy - not recommended to be used over the internet and > other wan > > networks where speed doesn't come easy. > > You might find that the application is exceptionally slow and your ADO > > connections are timing out over slow networks; I suggest you use a > database > > backend that is network friendly and has a very light protocol. Or > build a 3 > > tier system where the clients run an application that communicate the bare > > nessessities to an application server which translates into the commands > > that will hit the database. > > Hope this helps > > PO Box 627 00502 Karen, > > Nairobi, Kenya. > > Mobile: +254 722 996532 > > Fixed: +254 20 2050859 > > [EMAIL PROTECTED] com > > _____ > > From: [EMAIL PROTECTED] ps.com [mailto:[EMAIL PROTECTED] ps.com] > On Behalf > > Of edsynergy > > Sent: 30 April 2008 6:41 p > > To: [EMAIL PROTECTED] ps.com > > Subject: [delphi-en] Mssql Locking causes Delphi App to crash > > I have just gone live with a delphi app which has mssql at the backend. > > Under load testing it has been well behaved. It is now installed in a > > large health organisation with users coming in over wan connections to > > the sql server. For periods the system performs well and then it > > crashes. All other users of the system also crash out as well. The > > application will still launch and they can even log on but meaningful > > work is not possible. > > I have reviewed the code and cannot find an issue there. It would be > > easy for me to blame the network/ old pc's ( and not doubt the clients > > IT support could point a the software) but I rather get to the bottom > > of it. The sql server is not on a dedicated server. It is one of > > these new fangled virtual servers and I wonder if this is the issue. > > After all it is only using the chunk of memory allocated to it by the > > real server it is on. Would this impact on performance. Any views > > would be much appreciated. > > [Non-text portions of this message have been removed] > > > > > > > > > > > > __________________________________________________________ > Be a better friend, newshound, and > know-it-all with Yahoo! Mobile. Try it now. > http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ > <http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ> > > [Non-text portions of this message have been removed]
