G'day Frank,
That being the case I would look in Win2000 for what in NT4 was
a write behind setting that was by default ON but which for data
security should be OFF.
In NT it was found by right clicking My Computer\Properties then
I think from memory Advanced?
I looked in Win2K help for write behind caching to no avail.
Anyone know what it is hidden under?
At 07:09 PM 09/09/2001 -0700, you wrote:
>Yes, the server is a W2k server and the workstations are running Win2000
>prof.
>
>Frank Radice
>[EMAIL PROTECTED]
>
>
>
>-----Original Message-----
>From: Emmitt Dove [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, September 09, 2001 6:20 AM
>To: [EMAIL PROTECTED]
>Subject: Re: Indexing speed
>
>
>Frank,
>
>Are you running on W2k Server? We've been experiencing some issues that I
>can only attribute to a delayed cache write on the server, but I don't have
>that confirmed yet.
>
>In your case, the subsequent lookup might fail if the write hasn't yet
>taken place on the server.
>
>Emmitt
>
> >I have a form (Edit using...) that has an EEP containing "NEWROW", that
>adds
> >a new row, when necessary. The row contains an integer autonumber column
> >that is indexed.
> >
> >Users get to the "newrow" OK and when they "Exit from a row", there is an
> >EEP that does an update on the row (using the autonumber column in the
>where
> >clause in the update) .
> >
> >Everything works fine 99.99% of the time, however, every so often the EEP
> >returns error 2059 ("No rows exist or satisfy the specified clause"). I
> >have put in code in the EEP that looks at selected variables/values when
> >this error happens and the info seems OK (The row actually seems to be
> >there). This problem only seems to happen with the fastest entry people
> >during the busiest part of the day.
> >
> >This problem Never happens when they are editing previously existing rows.
> >
> >Since the referenced column is indexed, I was wondering if there might be
> >some significant lag time in creating the index and thus even though the
>row
> >exists, the where clause can't find it because the indexing hasn't
> >completed.
> >
> >Am running RB DOS 6.5++ with WIN2000 OS
> >
> >Programs seem to execute slower with our WIN2000 server than with our old
> >Novell server. Could this "speed down" be a factor?
> >
> >Any thoughts?
> >
> >Frank Radice
> >[EMAIL PROTECTED]
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 612 9552 3311
fax: 612 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
This email and any files transmitted with it are confidential to the
intended recipient and may be privileged. If you have received this email
inadvertently or you are not the intended recipient, you may not
disseminate, distribute, copy or in any way rely on it. Further, you should
notify the sender immediately and delete the email from your computer.
Whilst we have taken precautions to alert us to the presence of computer
viruses, we cannot guarantee that this email and any files transmitted with
it are free from such viruses.
