Problem solve Get help with specific problems with your technologies, process and projects.

Increasing speed of MS Data Engine/SQL Server environment

I have made a client server environment with Microsoft Data Engine on the client side and SQL Server 7.0 on the...

server. The software has 35 clients and one server. All the clients have Windows 98, and Windows 2000 Server is the operating system of the server. The OS of the server can be changed. The software is designed using Microsoft Visual Basic 6.0.

The present system is such that three of the most active nodes have Microsoft Data Engine as the database server, which is then connected to the SQL Server (main), but still, I am not getting the speed. Please suggest to me the ideal way to increase the performance of the software.

I am not sure why you would have MSDE on the clients if you have a SQL Server, unless the clients are periodically disconnected from the network (or if you have a slow network between clients), or you have a unique functionality requirement that doesn't fit with the normal client/server approach.

If the clients are permanently connected, and you are on a LAN, and assuming you have an adequately configured server, most people get good performance having the clients communicate directly with a centralized server bypassing the need for a local data repository. SQL Server is capable of processing hundreds (and much more on larger severs) of transactions a second when used this way. Performance problems in this situation are usually tied to a difficult to query database design, inappropriate SQL, or inadequate optimization (such as indexing). This however is dependant on the functionality of your application which hasn't been described in your question so I make not judgment if any of these relate to your situation.

You may have a valid reason for using the architecture you have described, in which case you will need to provide more information.


For More Information

This was last published in January 2003

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.