[DUG] Application problems

[Maurice Butler]

Are you flushing data after each update? ie forcing it to write the data to
disk instead of cache it then doing update as it feels
 
Maurice Butler

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] On
Behalf Of Eion McIntosh (Christchurch)
Sent: Tuesday, 26 September 2006 10:48 a.m.
To: delphi at ns3.123.co.nz
Subject: [DUG] Application problems



Hi 

We have an application we have been using for years, using dbase tables,
running on a server with users using a terminal services session to access
the application. It has been running perfectly on an old server, running
about 500mhz.

The issue we are having is that we have moved the application onto a new
server, 3.6ghz, so its much faster, but we are finding that some database
updates are either being lost or are not completing until a user quits the
session. If they make a change and then do some other things in the app and
then come back to the change it still shows as being done, but if we
physically look at the database, at that moment, we do not see that change
has been actioned. It may then get lost or not complete the update until
they quit. Some reports are not show the correct results even though all the
data is correct and if I run it from a copy of the system locally, it is
fine. Also if doing a search on name then it may only show A to K, and not
until you choose L-Z do you get the rest when you should be seeing A-Z all
the time.

We are starting to get frustrated at this and are wondering if some sort of
server CPU or disk caching that could be causing the system to appear to not
function correctly. I have pulled all the files twice and manually reindexed
them and things appear ok for a while and then go screwy, technical term,
again later on.

As far as we know the BDE is all set up correctly and the application does
run nice and fast and data can be viewed ok, it just they way it returns or
updates some data.

If anyone able to get any guidance or suggestions? 

Regards 
Eion McIntosh 
PPCS Ltd 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20060926/a9062a36/attachment.html