I have a client who swears that his reports ran 5 times faster using
BDE rather than DBISAM. Has anyone else had such problems when using
remote connections?

TIA,
Glynn

Can BDE work in Client/Server mode?

"Glynn Owen" <glynnMowenREMOVE@hotmail.comDELETE> escribió en el mensaje
news:412CFA37-F2C5-4F62-A841-DA1ED25C6688@news.elevatesoft.com...
>I have a client who swears that his reports ran 5 times faster using
> BDE rather than DBISAM. Has anyone else had such problems when using
> remote connections?
>
> TIA,
> Glynn

Santy Concepcisn wrote:

> Can BDE work in Client/Server mode?
>
> "Glynn Owen" <glynnMowenREMOVE@hotmail.comDELETE> escribis en el
> mensaje
> news:412CFA37-F2C5-4F62-A841-DA1ED25C6688@news.elevatesoft.com...
> > I have a client who swears that his reports ran 5 times faster using
> > BDE rather than DBISAM. Has anyone else had such problems when using
> > remote connections?
> >
> > TIA,
> > Glynn


Are you saying that the Client/Server mechanism is the reason for the
slow reports? I don't think so. Maybe partly, but not to the extent I
mentioned.

Regards,
Glynn

--

Glynn

Could you post the *idea* of this report ? This is working tables and/or
queries ? If it is using queries, all of them are optimized ? Have you
checked the indexes, the case-sensitive indexes ?

DBISAM is really fast, but you can give it the right condition to be fast.

Eduardo

Glynn,

<< I have a client who swears that his reports ran 5 times faster using BDE
rather than DBISAM. Has anyone else had such problems when using remote
connections? >>

You'll have to give us some more information.  Is the report running against
a table component(s), query component(s), or both ?   Are you setting the
TDBISAMTable/Query.RemoteReadSize property at all ?  What report engine are
you using ?  Is this running over a LAN or a WAN ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Glynn,
>
> << I have a client who swears that his reports ran 5 times faster
> using BDE rather than DBISAM. Has anyone else had such problems when
> using remote connections? >>
>
> You'll have to give us some more information.  Is the report running
> against a table component(s), query component(s), or both ?   Are you
> setting the TDBISAMTable/Query.RemoteReadSize property at all ?  What
> report engine are you using ?  Is this running over a LAN or a WAN ?


I don't know. I wrote the maintenance functions for the tables, but
someone else wrote the reports. I'll check into it a little deeper and
get back to you.

Thanks,
Glynn

Glynn


No he's saying that he doesn't think BDE has a c/s mode so it might be a case of comparing apples and oranges.

Roy Lambert

"Glynn Owen" <glynnMowenREMOVE@hotmail.comDELETE> wrote in message
news:A5ABEBC0-A853-4294-A078-D90EE3C576D4@news.elevatesoft.com...
>> report engine are you using ?  Is this running over a LAN or a WAN ?
>
>
> I don't know. I wrote the maintenance functions for the tables, but
> someone else wrote the reports. I'll check into it a little deeper and
> get back to you.
>

BDE was always extremely fast at "brute force" queries. In all probability,
you need additional indexes for the joins.

Robert

Robert wrote:

>
> "Glynn Owen" <glynnMowenREMOVE@hotmail.comDELETE> wrote in message
> news:A5ABEBC0-A853-4294-A078-D90EE3C576D4@news.elevatesoft.com...
> > > report engine are you using ?  Is this running over a LAN or a
> > > WAN ?
> >
> >
> > I don't know. I wrote the maintenance functions for the tables, but
> > someone else wrote the reports. I'll check into it a little deeper
> > and get back to you.
> >
>
> BDE was always extremely fast at "brute force" queries. In all
> probability, you need additional indexes for the joins.
>
> Robert

Sounds reasonable. I'll check into it.

Regards,
Glynn

--

Tim Young [Elevate Software] wrote:

> Glynn,
>
> << I have a client who swears that his reports ran 5 times faster
> using BDE rather than DBISAM. Has anyone else had such problems when
> using remote connections? >>
>
> You'll have to give us some more information.  Is the report running
> against a table component(s), query component(s), or both ?   Are you
> setting the TDBISAMTable/Query.RemoteReadSize property at all ?  What
> report engine are you using ?  Is this running over a LAN or a WAN ?

There are 18 TDBISAMTable components on 1 datamodule. Each has at least
one datasource attached. All use the default TDBISAMDatabase and
TDBISAMSession components. I assume that means that the connection is
local - the database is physically located on the same machine. The
report engine is Report Builder from Digital Metaphors.

The report runs against a Customer table with about 800 records indexed
by Customer Code. The report is grouped by Customer Code with at least
one page per customer.

I watched this run over a Remote DeskTop Connection. I can understand
the complaint. There are about 800 customer records in the report, and
it took 5 minutes to churn through the first 100.

Any suggestions about what I can do to speed this up?

TIA,
Glynn