Slow edit in VFP 6 after connection to SQL Server 1

[JackTheC]

Hi,

We are currently working on a new program in which we make a connection to SQL Server via a connectionstring (ODBC).
We use remote views to write updates to SQL Server.

When we start VFP 6.0 and edit a program (PRG) everythings goes smoothly.
When we run te program (and connect to SQL Server) and than terminate the program to re-edit something, the (built-in) VFP-editor is very slow; a wait b wait c etc.

We tried close all, clear all, release all and the display memo and display status shows nothing strange.
Connections are closed.
But the editor is slow. Quiting VFP and restarting VFP solves the problem until we run again.

Any ideas???

 

[Mike Lewis]

Have you tried pausing the SQL Server connection (using the SQL Server Connection Tool in the system tray)? I'm not sure if that would make a difference, but it might be worth a try.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[rgbean]

Are you starting up the debugger in the background by any chance?

Rick

 

[JackTheC]

Hi,

The connections are closed, so pausing isn't possible.
And I have no debugger in the background. Opening one doesn't solve it. (nor closing).

I tried an external editor (TEDIT in CONFIG.FPW) and this does solves the slowness problem. But of course now I don't have the benefits of the built-in editor like syntax coloring etc.

Greeting,

JackTheC

 

[agit72]

JackTheC,
You may review the FAQ about Memory Management (faq184-3504)

http://www.tek-tips.com/faqs.cfm?spid=184&sfid=3504

and don't forget to give any comment...


Agit Permana (08561052915)
Mitra Solusi Pratama, PT

http://www.msp-works.com

 

[JackTheC]

Only the built-in editor becomes slow.
Typing in the Command-Window is normal.
The application in Run-mode also just works fine.

 

[rgbean]

JackTheC,
OK, I'll ask the "obvious" questions:
1) What SP of VFP 6.0 are you running? (SP5?)
2) What OS are you running?
3) How much memory does this workstation have?
4) What else are you running?
5) If running a virus checker, have you read "HOWTO: Optimize Visual FoxPro Applications While Using Norton AntiVirus 2002" -

http://support.microsoft.com/default.aspx?scid=kb;en-us;321550?

Note: The concepts apply to other versions of Norton AND other virus checkers - just the details will change.

Rick

 

[JackTheC]

1) SP5
2) NT 4.0 on client and on Server
3) 128 MB
4) Nothing
5) Mcafee

 

[rgbean]

I know I'm being picky but, are you running NT 4.0 SP6a? Any chance you can add some memory - I'd consider 128MB "minimal" with VFP 6.0 and NT. Is McAfee set up to ignore all the changes on the basic developer files (.PRG, .VCT&VCT, .FXP, etc.), along with .DBF, .CDX and .FPT files?

I ran VFP 6.0 SP5 on NT 4.0 (w/ 256MB) for 2+ years and never saw what you are describing. I usually had Outlook and Norton AV running and occaisionally a SETI client (which "eats" all extra CPU cycles available!).

Rick

 

[JackTheC]

I too don't have the slow edit program when working on normal (not remote views) project.
This is my first SQL-Server project ever. And the first time I (we) see this problem in the editor.

On my other (stand-alone) PC I have Windows 98 installed with just 64 MB of ram and even in my remote view project I see no speed degradation. But in this case a development SQL server is installed on this PC too.

The problem only occurs on my NT 4.0 SP6a after using a remote view (and closing it) with tables on a SQL server on the network.
And only in the Editor. In run-mode the application (with even multiple remote views) works fine.
The same effect can been seen on the PC of my colleague who has even a faster PC.