Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record is not available. Please wait
Message
From
29/11/1999 07:24:23
 
 
To
29/11/1999 05:02:22
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00296300
Message ID:
00296319
Views:
19
Hej!
I have seen this problem in VFP 6.0

It turned out the problem was related to the locking order on the
table in question.

I added the following code at the start of my program
=SYS(3052,1,.T.) && Changes the lock and write order
=SYS(3052,2,.T.)

Please also see:
http://support.microsoft.com/support/kb/articles/Q125/5/76.asp
Which may help I think there is something funny with Novell networks.

Here are somemore misc notes from my bug database which may also
be relevent...

Some users get a Scrolling.. Record Not Found Error..
Please first see the article at :
http://support.microsoft.com/support/kb/articles/q125/5/76.asp

Here are more suggestions....

-Also could be due to Index Corruption....
-Delete all the CDX files and RUN A SYSTEM CHECK WITH
CREATE TAGS
in the syscheck.ini file.

-Also try Deleting TMP files and CHK Files... From the users temp directories.

It's quite possible there are some setting on the NT server that have a problem...
But I am not sure what yet...
These settings apply to any database server not just Oracle...

Try to change the following on the NT server.
1) Optimize for network throughput. This setting instructs NT to allocate
resources such that they are more available and useable to application
processes that execute locally on the server. This setting defaults to
"Optimize for file sharing", and modifying this setting will typically
generate a performance improvement of 5-10% in the ORACLE
instance. Note that this setting requires a reboot before it takes effect.
This setting can be found in the following location:

START -> Settings -> Control Panel -> Network -> Services ->
Server -> Properties -> Maximize throughput for network applications

2) Minimize foreground boost. This setting allows NT Servers that
perform additional duties as user workstations to allocate more
resources to interactive sessions that are logged into the console, and
defaults to 50%. Assuming this box is a dedicated database server, then
this setting should be set such that interactive logins are not given
priorities higher than the ORACLE services. Due to NT's architecture,
certain administrative tasks may require console login, and it is
undesirable for the database end-users to experience a performance
degradation each time an interactive login occurs. This setting essentially
minimizes a 5-10% degradation during interactive login sessions. Note
that this setting requires a reboot before it takes effect. This setting can
be found in the following location:

START -> Settings -> Control Panel -> System -> Performance ->
Foreground boost = none

-Also you can try to use the following tools to analyze performance...

1) Use this...START - run - 'perfmon'
Then use this chart...attached performance.pmc
To monitor server process queue.

Note any large fluctions....

2) Try this tool NTFiLEMON: I have never used it....
To monitor open files...See if you can see a pattern.....


HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform