Well with your history, it seems like something else is going on.
I can tell you my BAQ's & CR's that use the BAQ's are extremely fast for the vast majority, the ones that are slow I'd expect to be slow from the vast amounts of data being dumped.
Sounds like a configuration issue somewhere along the way. Wish I could be of more help.
on behalf of hoomail4me
Sent: Tue 1/15/2008 11:19 PM
Subject: [Vantage] Re: Custom CR's from BAQ Report Designer
> We avoid ODBC like the plague. The largest BAQ report I've written
dumped 80mb of data and took 20 minutes to process. Otherwise, all
reports print in under a minute.
I tried like hell to avoid ODBC but it is so easy and run rings around
the performance of BAQ/CR.
> So, your issues:
> 1. BAQ query limitations. Every time I've thought I've hit a
limitation, I've figured away around it. The only time I couldn't get
BAQ query to properly combine what I needed, I dumped it all into
Crystal and did the link there. Tell me more about your limitations
and I can perhaps offer some tips.
Query phrase very limiting - one simple example of what couldn't be done:
FOR EACH partmtl NO-LOCK WHERE partmtl.fixedqty = NO OR
(partmtl.fixedqty = YES AND (INTEGER(partmtl.qtyper) / partmtl.qtyper
> 2. Idiosyncrasies of the UI. Okay, you've got a great one there, I
freaking hate the 48 steps to get everything working, but having made
~50-75 reports, I've finally 'mastered' these issues.
Too many to list - something as simple as changing a query phase after
is is built. Most of the time it is easier to start over.
> 3.Slow performance. I'm curious about your queries and your system
agent setup. The system agent can be set to x amount of time to look
for print jobs. We have ours set to 30 seconds which seems perfectly
adequate. If yours is set to a few minutes this is going to be huge.
Are your queries properly linked to each other? If I setup a bad BAQ
it can get stuck anywhere from minutes to hours depending on how bad I
System agent is set to 5 seconds.
I keep hearing this "Are the query joins correct..." in the message
threads I have found on this subject. I cannot say that ALL are
optimized but I have been writing Progress code for 10 years and never
had a problem with query/report performance. What could I possibly be
doing wrong all the time with BAQ queries for CR.
> Post more details, I love the BAQ/Crystal setup now that I've
practiced enough in it.
I like the concept but the implementation doesn't seem to work!
[Non-text portions of this message have been removed]