Speed up applications

Why are dBase programs (.exe) so slow to load and so slow and unstable to 
run?  And, more importantly, how can I fix the problem?

The applications I write for my office take forever to load and are jittery 
when you move the mouse over them.  What can be done about this?

-- 
Dan Anderson
UBI Processing Dept.
andersond@ubinc.com
800-444-4824 ext 101 

Hi Dan,

> Why are dBase programs (.exe) so slow to load and so slow and unstable to 
> run?  And, more importantly, how can I fix the problem?
>
> The applications I write for my office take forever to load and are 
> jittery when you move the mouse over them.  What can be done about this?

In order to help you we need alot more information about your programming.
In general, dBASE .exe's load very fast and run very reliably.

Can you post which version of the dBASE runtime engine you are running
your .exe's with AND what version of Windows?
Are you running on a newer PC or an older one - more than 5 years old.

Are you running your .exe's across a network?
Are you using Terminal Services to allow multiple users to share a single 
server?

Have you tried testing your app with some parts of its startup code 
commented out
to try and pinpoint where you may have a lengthy operation in your code?

If you are willing, you can post the source code for your startup code in a 
newsgroup message
so others here can review it and offer suggestions.

Alternatively, you can contact our Tech Support department and arrange to 
upload your
application to us so we can assist you with optimizing it. We would then 
have a better chance
at seeing the stability and jittery issues you are describing.   The 
optimizing assistance would likely be a
billable tech support incident.

See http://www.dbase.com/dBase_Cust_Ser_Tech_Support.asp
for details about our Tech Support offerings.

- Marty -

Martin Kay
dataBased Intelligence, Inc.

Dan,

The single most frequent speed issue I have run into is virus checkers.  In
particullar, some versions of Norton reduced the speed of my app by 70 %.  That
could be improved with some tweeking of Norton, but I just have my clients
switch to any other virus checker and that significantly improved the speed.

Easy to test this.  Just try disabling your virus checker for a brief time and
run your app.  Then try any other of the free demo versions of other virus
checkers to see the resulting speed difference.

HTH,
Mark

Dan Anderson Wrote:

> Why are dBase programs (.exe) so slow to load and so slow and unstable to 
> run?  And, more importantly, how can I fix the problem?
> 
> The applications I write for my office take forever to load and are jittery

> when you move the mouse over them.  What can be done about this?
> 
> -- 
> Dan Anderson
> UBI Processing Dept.
> andersond@ubinc.com
> 800-444-4824 ext 101 
> 
> 

I have never had any issues with speed except for networking (while so using 
non-optimized querys / filters).
For example if your pulling large amounts of data accross a LAN and this 
data involves filters and or select statements that are not taking advantage 
of indexes then you will surely see slow performance.

I would reccomend a Terminal Server if you have large tables with lots of 
unoptimized queries.

Like Marty says, we need to understand more about your app.

Maybe you can give us a description or some code for the area where you are 
seeing the most trouble.



Greg Hill


"Dan Anderson" <andersond@ubinc.com> wrote in message 
news:XBT97PlmIHA.960@news-server...
> runtime version 2.1.6.4
> Windows XP
> Intel Pentium 4 processor
> 512Mb RAM
> over Windows network
> 2,472 lines of code, another is 9,597
> Are you sure you want me to post this to the newsgroup?
>
> -- 
> Dan Anderson
> UBI Processing Dept.
> andersond@ubinc.com
> 800-444-4824 ext 101
> "Marty Kay" <mkay@databi.com> wrote in message 
> news:SBEGDwkmIHA.1388@news-server...
>> Hi Dan,
>>
>>> Why are dBase programs (.exe) so slow to load and so slow and
unstable 
>>> to run?  And, more importantly, how can I fix the problem?
>>>
>>> The applications I write for my office take forever to load and are

>>> jittery when you move the mouse over them.  What can be done about
this?
>>
>> In order to help you we need alot more information about your 
>> programming.
>> In general, dBASE .exe's load very fast and run very reliably.
>>
>> Can you post which version of the dBASE runtime engine you are running
>> your .exe's with AND what version of Windows?
>> Are you running on a newer PC or an older one - more than 5 years old.
>>
>> Are you running your .exe's across a network?
>> Are you using Terminal Services to allow multiple users to share a
single 
>> server?
>>
>> Have you tried testing your app with some parts of its startup code 
>> commented out
>> to try and pinpoint where you may have a lengthy operation in your
code?
>>
>> If you are willing, you can post the source code for your startup code
in 
>> a newsgroup message
>> so others here can review it and offer suggestions.
>>
>> Alternatively, you can contact our Tech Support department and arrange
to 
>> upload your
>> application to us so we can assist you with optimizing it. We would
then 
>> have a better chance
>> at seeing the stability and jittery issues you are describing.   The 
>> optimizing assistance would likely be a
>> billable tech support incident.
>>
>> See http://www.dbase.com/dBase_Cust_Ser_Tech_Support.asp
>> for details about our Tech Support offerings.
>>
>> - Marty -
>>
>> Martin Kay
>> dataBased Intelligence, Inc.
>>
>>
>>
>
> 

runtime version 2.1.6.4
Windows XP
Intel Pentium 4 processor
512Mb RAM
over Windows network
2,472 lines of code, another is 9,597
Are you sure you want me to post this to the newsgroup?

-- 
Dan Anderson
UBI Processing Dept.
andersond@ubinc.com
800-444-4824 ext 101
"Marty Kay" <mkay@databi.com> wrote in message 
news:SBEGDwkmIHA.1388@news-server...
> Hi Dan,
>
>> Why are dBase programs (.exe) so slow to load and so slow and unstable
to 
>> run?  And, more importantly, how can I fix the problem?
>>
>> The applications I write for my office take forever to load and are 
>> jittery when you move the mouse over them.  What can be done about
this?
>
> In order to help you we need alot more information about your programming.
> In general, dBASE .exe's load very fast and run very reliably.
>
> Can you post which version of the dBASE runtime engine you are running
> your .exe's with AND what version of Windows?
> Are you running on a newer PC or an older one - more than 5 years old.
>
> Are you running your .exe's across a network?
> Are you using Terminal Services to allow multiple users to share a single 
> server?
>
> Have you tried testing your app with some parts of its startup code 
> commented out
> to try and pinpoint where you may have a lengthy operation in your code?
>
> If you are willing, you can post the source code for your startup code in 
> a newsgroup message
> so others here can review it and offer suggestions.
>
> Alternatively, you can contact our Tech Support department and arrange to 
> upload your
> application to us so we can assist you with optimizing it. We would then 
> have a better chance
> at seeing the stability and jittery issues you are describing.   The 
> optimizing assistance would likely be a
> billable tech support incident.
>
> See http://www.dbase.com/dBase_Cust_Ser_Tech_Support.asp
> for details about our Tech Support offerings.
>
> - Marty -
>
> Martin Kay
> dataBased Intelligence, Inc.
>
>
>