Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.Exe
Message
From
04/06/2002 14:56:15
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Re: .Exe
Miscellaneous
Thread ID:
00662633
Message ID:
00664676
Views:
17
>Hi All:
> I am creating an .EXE from a source files which are located on Sql Server 7.0. If I am mapped to the drive where my source files are located, my .EXE runs fast, however if I remove the drive mapping to my source files, the .EXE runs very slow. There is no code in my project that would reference the source files. Then why do I need to mapped to the drive where the source files are located in order for my .EXE to run fast? Is this a Sql Server 7.0 thing? How can I solve this problem?
>Thanks

Because I am uncertain what actually your problem is, I will just explain what I have understand. Correct me, if I am wrong.

You have an VFP application, which queries against SQL Server 7.0. The source code of that application is located at the same machine, that runs SQL Server 7.0. When you have drive mapping to the drive, where the source code is located - the EXE runs faster. So you ask why it runs slower without such a mapping.

Try the following, if you have more than one drive on the server: map a drive, that does not have the source, and check whether you exe runs slower/faster.

What kind of SQL Server user authentication do you use? Windows trusted or both SQL Server and Windows trusted?
Do you create objects from your classes dynamically (e.g. with CreateObject, Newobject or AddObject)?

HTH
Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform