problem with the client-server model (VB.Net +SQL- application becomes slow)
-
I have an application that resides on a LAN and has connections to a SQL database. Obviously, on the server machine (where sql server is loaded) the application program (designed in VB.net) works fine .But when i try to run the same aplication from client machine (access SQL server) the apllication becomes very slow. What all the precosions need to be taken to take care of application speed in Client- server based applications. Clients consist of both XP. RAM 512 MB.
-
I have an application that resides on a LAN and has connections to a SQL database. Obviously, on the server machine (where sql server is loaded) the application program (designed in VB.net) works fine .But when i try to run the same aplication from client machine (access SQL server) the apllication becomes very slow. What all the precosions need to be taken to take care of application speed in Client- server based applications. Clients consist of both XP. RAM 512 MB.
Your Question is broad, there can be many things that can make the Application to be Slow, we dont know your environment. But on the Application side mybe it will be better to explain slowness you are talking about. Is it slow in all the parts of the System or on certain parts, for example, is it slow when to connect to the database ? Something like that try to explain, any mybe post code that connects to the datase or it mybe the database side we dont know
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswam@its.co.za
-
Your Question is broad, there can be many things that can make the Application to be Slow, we dont know your environment. But on the Application side mybe it will be better to explain slowness you are talking about. Is it slow in all the parts of the System or on certain parts, for example, is it slow when to connect to the database ? Something like that try to explain, any mybe post code that connects to the datase or it mybe the database side we dont know
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswam@its.co.za
-
Yes, I will explain in detail. The application becomes slow whenever it tries to access database. Otherwise it runs fine.
ok, Can please show us a code snippet when you connect to the the Dabase or when you execute database code.
Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswam@its.co.za