Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 10 of 13 total |
Slow Reports |
Fri, Jun 1 2007 12:58 AM | Permanent Link |
"Glynn Owen" | 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 |
Fri, Jun 1 2007 5:37 AM | Permanent Link |
"Santy Concepción" | 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 |
Fri, Jun 1 2007 2:14 PM | Permanent Link |
"Glynn Owen" | 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 -- |
Fri, Jun 1 2007 3:38 PM | Permanent Link |
"Jose Eduardo Helminsky" | 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 |
Fri, Jun 1 2007 3:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Jun 1 2007 6:13 PM | Permanent Link |
"Glynn Owen" | 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 |
Sat, Jun 2 2007 6:54 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Sat, Jun 2 2007 9:51 AM | Permanent Link |
"Robert" | "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 |
Sat, Jun 2 2007 7:22 PM | Permanent Link |
"Glynn Owen" | 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 -- |
Sun, Jun 10 2007 12:52 AM | Permanent Link |
"Glynn Owen" | 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 |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |