Easy to Create, Easy to Change - Easy to use!


windows 7 as a server


Started by wilmer raul contreras riaño
Search
You will need to Sign In to be able to add or comment on the forum!

windows 7 as a server

is there any difference in the performance of my database if this is on a machine running Windows 7 Professional or necessarily must be in Windows 2008 Server R2
Written by wilmer raul contreras riaño 02/11/12 at 18:22:09

Re:windows 7 as a server

There is a lot of stuff that can impact on the performance of your database. DataEase for Windows is basically several indepenent applications that share the same files (database). The server itself perform no task, except being a file server or a shared harddrive. In general it would be better to have a proper server (hardware) that ran Windows 7, than a normal PC that run Windows 2008 R2 server, this is because the hardware in a server is set up to be good on I/O with better harddrive specs, bus, network transfer and troughput etc. When it comes to the performance of a DataEase database in a network, it is more important that the Work station has a good spec, than the server. All the work happens on the workstation, and the speed problem goes geometrical when your Workstations starts to swap memory to drive too. To be honest, if you have problems with the performance of a DataEase database when in a network, consider the following: 1. Do you run Full or Basic locking. If you are, why? 2. Why do you need to run this particluar procedure that is so heavy on a network drive? 3. It is likely that you do something "stupid" in the procedure, and that it would be more cost effective to spend some time to rewrite the procedure, than start buying more hardware. With "stupid" I don't mean that you are stupid, but there is several things one can do inadvertently that causes DataEase to stop using indexes and resort to sequatial searching etc. We have a tendency to do very complex stuff in a DataEase DQL that most other databases would simply not allow, but as long as we run it locally it doesn't even go slow. Do the same in a network situation with full locking and you need to brew a big kettle of coffee... I understand that you try to get to the bottom of something here, but I think you look in the wrong place.
Written by DataEase 02/11/12 at 19:54:23 DataEase for Windows 7.x