|
| Re: BDE Configuration |
 |
Wed, 21 Mar 2007 20:48:17 -070 |
"Terry" <tllmsod2@swbell.net> wrote in message
news:axu$fBDbHHA.1908@news-server...
> I'm looking for recommended settings to enhance preformance. Network
> application is freezing up. 15 users. Using BDE 5.2 dBase Plus 2.21 Lots
> of tables open, some upto 40 M.
There are some networking programming practices that would render the
settings in the BDE to be powerless. A common problem is filtering and or
sql select statements with complex where clauses. Sometimes building simple
indexes for each field that is in the where clause.
If the app design is not to reliant on sql "where clauses" then it is
better
to use setRange() and or other index methods for displaying data.
Is this a new app that you just deployed or are you seeing this slow down
gradualy get worse?
Greg Hill
|
| Post Reply
|
| BDE Configuration |
 |
Wed, 21 Mar 2007 22:15:42 -050 |
I'm looking for recommended settings to enhance preformance. Network
application is freezing up. 15 users. Using BDE 5.2 dBase Plus 2.21 Lots of
tables open, some upto 40 M.
|
| Post Reply
|
| Re: BDE Configuration |
 |
Wed, 21 Mar 2007 23:21:44 -050 |
Greg Hill Wrote:
> "Terry" <tllmsod2@swbell.net> wrote in message
> news:axu$fBDbHHA.1908@news-server...
> > I'm looking for recommended settings to enhance preformance. Network
> > application is freezing up. 15 users. Using BDE 5.2 dBase Plus 2.21
Lots
> > of tables open, some upto 40 M.
>
> There are some networking programming practices that would render the
> settings in the BDE to be powerless. A common problem is filtering and or
> sql select statements with complex where clauses. Sometimes building
simple
> indexes for each field that is in the where clause.
>
> If the app design is not to reliant on sql "where clauses" then
it is better
> to use setRange() and or other index methods for displaying data.
>
> Is this a new app that you just deployed or are you seeing this slow down
> gradualy get worse?
>
>
> Greg Hill
>
>
>
>
>
It's a work in progress, some 15 years. Just started having the problems in the
last 1-2 months.
|
| Post Reply
|
| Re: BDE Configuration |
 |
Thu, 22 Mar 2007 02:03:31 -040 |
In article <axu$fBDbHHA.1908@news-server>, tllmsod2@swbell.net says...
> I'm looking for recommended settings to enhance preformance. Network
application is freezing up. 15 users. Using BDE 5.2 dBase Plus 2.21 Lots of
tables open, some upto 40 M.
>
> Terry
Terry,
Be sure the BDE settings are not the default values but are set to their
maximum values. Things like MAXBUFFERSIZE, etc. The defaults are from
many years ago when computers had a lot less RAM.
--
Geoff Wass [dBVIPS]
Montréal, Québec, Canada
.|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
|
| Post Reply
|
| Re: BDE Configuration |
 |
Thu, 22 Mar 2007 08:19:30 -050 |
Geoff Wass [dBVIPS] Wrote:
> In article <axu$fBDbHHA.1908@news-server>, tllmsod2@swbell.net
says...
> > I'm looking for recommended settings to enhance preformance. Network
application is freezing up. 15 users. Using BDE 5.2 dBase Plus 2.21 Lots of
tables open, some upto 40 M.
> >
> > Terry
>
> Terry,
>
> Be sure the BDE settings are not the default values but are set to their
> maximum values. Things like MAXBUFFERSIZE, etc. The defaults are from
> many years ago when computers had a lot less RAM.
>
> --
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
>
> .|.|.| dBASE info at http://geocities.com/geoff_wass |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.| IT Consultant http://Geoff_Wass.com |.|.|.
Thanks Geoff,
Is there some where that I could refer to for suggestions on maximum setting?
|
| Post Reply
|
|
|
|
|
|
|
|
|
|