Re: .NET WindowForm Application Performance Issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

to me it looks like network issue. putting thing simle way:
1 to 2 seconds for a ping is quite a long time if you need fast db access with significant amount of data transfer. if one small packet needed so much time, then more and bigger packets will take a bit more time. if you compare this to localhost situation (db is locally) then difference will be significant.

Techstudent wrote: 
Thanks Bob and Helge for your responses.

Info about the application:

This windows application is segregated into presentation layer and Datalayer. the calls to the database(Oracle 9i database) is directly using ADO.NET(Provider:Oracle provider for .NET).The database is in a remote location , the call goes through two routers to get to the database. we did isolate the issue to internal network. when we ping the database the response times are around 1 to 2 seconds. the application gets slower based on the network traffic. we are using one T1 Line.
the netwrok guys telling that they can't do any thing to improve the performance of the network unless they get another line to increase the bandwindth.

In my application i do bulk insert or update to reduce round trips to the database.

I am not using any remoting or webservices and i am not sure how these will help me work around the network issue.

The highest priority is the performance of the application.

Note: If i connect to the local database the application performs very well.

I appreciate your suggestions

Thanks




"Bob Grommes" wrote:


You would have to tell us something about how the application is currently architected (multi tier mapped objects of some kind, or web services, or straight ADO.NET, what DB, using native drivers or not, etc) and what the network situation is. Offhand if I had to guess I would say that you have a network issue and/or the application is just not well designed and the extra network overhead is bringing this out.

I recently was part of a two man team that put together a fairly elaborate WinForms app and I found it quite snappy even though for testing purposes I was connecting to a remote DB, over the Internet, via a VPN. The customer was connecting the same way for testing and approval and there was never a complaint about performance from them, either. So the good news is, it *can* be done.

One's mileage can and will vary depending on all sorts of variables so in this situation you really need to do some profiling to find out where the bottlenecks actually are.

--Bob

Techstudent wrote:

I have windows form application on clients computer communicating with Database which is in a remote location in same network. We see considerable performance degradation due to this setup. If the client access the databaser locally the performace is lot better.

Does any one have any suggestions to architect the application to gain the performance.

Note:This windows application is used by mutliple users with in the network and application is installed on the users computer.


Thanks



.

Relevant Pages

  • Re: Audacity and Gentoo
    ... > Oracle Black Helicopter Base in Antarctica: `Hey, we've got a database, ... available, especially from Australia's ABC national radio network, ... I don't sync it with the computers, ... There's over 5,000 games in that 15 ...
    (uk.comp.os.linux)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: Replication/Sychronization and security
    ... When put on the network it takes several seconds for those close to ... I am told that our network drives are for data storage (word/excel ... explore the possiblity of replication as a solution. ... >> database to decrease the potential for breach. ...
    (microsoft.public.access.replication)
  • Re: Remote data entry solution needed for Access 2007
    ... Users open the database remotely and use its forms to enter data. ... Why it doesn't work: network lag time. ... our network admin says our Citrix server is 2000 and ... HTML-based form working with an ASP file to send data to the database. ...
    (microsoft.public.access.externaldata)
  • Re: Database Performance Problem between 3:00PM and 4:00PM
    ... where by database becomes extremely slow between 3:00PM and 4:00PM. ... When one looks at CPU Usage, Memory Usage and Disk Usage nothing ... FRom the beginning we suspected Network to be an issue, ... Is it possible that an Oracle backup job, export, or ...
    (comp.databases.oracle.server)