Customer Table slowing down BAQ

Yahoo Archive
1
All i have is the customer table - no filters and display of the name.



--- In vantage@yahoogroups.com, Robert Brown <robertb_versa@...> wrote:
>
> Include your BAQ in your email and perhaps something in the
statement syntax will jump out at one of us.
>
>
>
> --- On Sun, 7/6/08, mseal <mseal@...> wrote:
>
> From: mseal <mseal@...>
> Subject: [Vantage] Re: Customer Table slowing down BAQ
> To: vantage@yahoogroups.com
> Date: Sunday, July 6, 2008, 8:51 PM
>
>
>
>
>
>
> Thanks Dave
> does anyone have an idea what may be slowing my Customer table when
> selected in a BAQ?
> Thanks
>
> Motty
>
> --- In vantage@yahoogroups .com, "Dave Thomas" <dthomas@ > wrote:
> >
> > I just tested a simple BAQ on the customer table with 8000 records
> > with a 8.03.404B SQL database - ran in less than 3 seconds.
> >
> > Dave Thomas
> >
> > --- In vantage@yahoogroups .com, "mseal" <mseal@> wrote:
> > >
> > > Wonder if anyone has faced this problem with the customer table
> > > I have fewer than 15,000 rows in the table. When creating BAQs and
> > > linking multiple tables I get the results returned usually within
> > 5-10
> > > second. Once I add the customer table to the BAQ it can take 60-
> > 300 sec.
> > > I tested the customer table in a BAQ with no other links or filters
> > > and a single column return (name) and it takes 70 sec. If I
> > perform a
> > > similar test with my change-log table that has over 250,00 rows I
> > will
> > > get the results in about 8 sec.
> > > Epicor's answer to the issue is that I do get the results so there
> > is
> > > nothing wrong
> > > Does anyone know how to resolve this issue?
> > >
> > > Thanks
> > >
> > > Motty
> > >
> >
>
2
Wonder if anyone has faced this problem with the customer table
I have fewer than 15,000 rows in the table. When creating BAQs and
linking multiple tables I get the results returned usually within 5-10
second. Once I add the customer table to the BAQ it can take 60-300 sec.
I tested the customer table in a BAQ with no other links or filters
and a single column return (name) and it takes 70 sec. If I perform a
similar test with my change-log table that has over 250,00 rows I will
get the results in about 8 sec.
Epicor's answer to the issue is that I do get the results so there is
nothing wrong
Does anyone know how to resolve this issue?

Thanks

Motty
3
I just tested a simple BAQ on the customer table with 8000 records
with a 8.03.404B SQL database - ran in less than 3 seconds.

Dave Thomas

--- In vantage@yahoogroups.com, "mseal" <mseal@...> wrote:
>
> Wonder if anyone has faced this problem with the customer table
> I have fewer than 15,000 rows in the table. When creating BAQs and
> linking multiple tables I get the results returned usually within
5-10
> second. Once I add the customer table to the BAQ it can take 60-
300 sec.
> I tested the customer table in a BAQ with no other links or filters
> and a single column return (name) and it takes 70 sec. If I
perform a
> similar test with my change-log table that has over 250,00 rows I
will
> get the results in about 8 sec.
> Epicor's answer to the issue is that I do get the results so there
is
> nothing wrong
> Does anyone know how to resolve this issue?
>
> Thanks
>
> Motty
>
4
Thanks Dave
does anyone have an idea what may be slowing my Customer table when
selected in a BAQ?
Thanks

Motty

--- In vantage@yahoogroups.com, "Dave Thomas" <dthomas@...> wrote:
>
> I just tested a simple BAQ on the customer table with 8000 records
> with a 8.03.404B SQL database - ran in less than 3 seconds.
>
> Dave Thomas
>
> --- In vantage@yahoogroups.com, "mseal" <mseal@> wrote:
> >
> > Wonder if anyone has faced this problem with the customer table
> > I have fewer than 15,000 rows in the table. When creating BAQs and
> > linking multiple tables I get the results returned usually within
> 5-10
> > second. Once I add the customer table to the BAQ it can take 60-
> 300 sec.
> > I tested the customer table in a BAQ with no other links or filters
> > and a single column return (name) and it takes 70 sec. If I
> perform a
> > similar test with my change-log table that has over 250,00 rows I
> will
> > get the results in about 8 sec.
> > Epicor's answer to the issue is that I do get the results so there
> is
> > nothing wrong
> > Does anyone know how to resolve this issue?
> >
> > Thanks
> >
> > Motty
> >
>
5
> does anyone have an idea what may be slowing my Customer table when
> selected in a BAQ?

Have you checked the links used in the Join? If Progress is not using the
proper, or any, index, it could definitely give you the response time that
you're seeing.

Mark W.
6
Thanks Mark,
no, in this case I have NO links only the Customer table.
If I create a BAQ for example for my orders and run it, I will get a
response in 2-3 sec. for 6000 rows. if I add the customer table it
will take 30-50 sec.
no matter what BAQ I add the customer table or if I access it directly
with no other joins, it always takes forever....


Thanks

Motty

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> > does anyone have an idea what may be slowing my Customer table when
> > selected in a BAQ?
>
> Have you checked the links used in the Join? If Progress is not
using the
> proper, or any, index, it could definitely give you the response
time that
> you're seeing.
>
> Mark W.
>
7
Motty



Try adding into the filter screen, Customer.Company = (Company ID}



This can sometimes activate indexes

Gary Parfrey

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mseal
Sent: 07 July 2008 14:37
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customer Table slowing down BAQ



Thanks Mark,
no, in this case I have NO links only the Customer table.
If I create a BAQ for example for my orders and run it, I will get a
response in 2-3 sec. for 6000 rows. if I add the customer table it
will take 30-50 sec.
no matter what BAQ I add the customer table or if I access it directly
with no other joins, it always takes forever....

Thanks

Motty

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Mark Wonsil" <mark_wonsil@...> wrote:
>
> > does anyone have an idea what may be slowing my Customer table when
> > selected in a BAQ?
>
> Have you checked the links used in the Join? If Progress is not
using the
> proper, or any, index, it could definitely give you the response
time that
> you're seeing.
>
> Mark W.
>





[Non-text portions of this message have been removed]
8
What version of Vantage and are you SQL or Progress?

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mseal
Sent: Monday, July 07, 2008 9:37 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Customer Table slowing down BAQ



Thanks Mark,
no, in this case I have NO links only the Customer table.
If I create a BAQ for example for my orders and run it, I will get a
response in 2-3 sec. for 6000 rows. if I add the customer table it
will take 30-50 sec.
no matter what BAQ I add the customer table or if I access it directly
with no other joins, it always takes forever....

Thanks

Motty

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Mark Wonsil" <mark_wonsil@...> wrote:
>
> > does anyone have an idea what may be slowing my Customer table when
> > selected in a BAQ?
>
> Have you checked the links used in the Join? If Progress is not
using the
> proper, or any, index, it could definitely give you the response
time that
> you're seeing.
>
> Mark W.
>






[Non-text portions of this message have been removed]
9
Running SQL2005 with Vantage 803.404
all other tables run fast when added into a BAQ except for the
customer table

Thanks

Motty

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> What version of Vantage and are you SQL or Progress?
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of mseal
> Sent: Monday, July 07, 2008 9:37 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Customer Table slowing down BAQ
>
>
>
> Thanks Mark,
> no, in this case I have NO links only the Customer table.
> If I create a BAQ for example for my orders and run it, I will get a
> response in 2-3 sec. for 6000 rows. if I add the customer table it
> will take 30-50 sec.
> no matter what BAQ I add the customer table or if I access it directly
> with no other joins, it always takes forever....
>
> Thanks
>
> Motty
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Mark Wonsil" <mark_wonsil@> wrote:
> >
> > > does anyone have an idea what may be slowing my Customer table when
> > > selected in a BAQ?
> >
> > Have you checked the links used in the Join? If Progress is not
> using the
> > proper, or any, index, it could definitely give you the response
> time that
> > you're seeing.
> >
> > Mark W.
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
10
Include your BAQ in your email and perhaps something in the statement syntax will jump out at one of us.



--- On Sun, 7/6/08, mseal <mseal@...> wrote:

From: mseal <mseal@...>
Subject: [Vantage] Re: Customer Table slowing down BAQ
To: vantage@yahoogroups.com
Date: Sunday, July 6, 2008, 8:51 PM






Thanks Dave
does anyone have an idea what may be slowing my Customer table when
selected in a BAQ?
Thanks

Motty

--- In vantage@yahoogroups .com, "Dave Thomas" <dthomas@... > wrote:
>
> I just tested a simple BAQ on the customer table with 8000 records
> with a 8.03.404B SQL database - ran in less than 3 seconds.
>
> Dave Thomas
>
> --- In vantage@yahoogroups .com, "mseal" <mseal@> wrote:
> >
> > Wonder if anyone has faced this problem with the customer table
> > I have fewer than 15,000 rows in the table. When creating BAQs and
> > linking multiple tables I get the results returned usually within
> 5-10
> > second. Once I add the customer table to the BAQ it can take 60-
> 300 sec.
> > I tested the customer table in a BAQ with no other links or filters
> > and a single column return (name) and it takes 70 sec. If I
> perform a
> > similar test with my change-log table that has over 250,00 rows I
> will
> > get the results in about 8 sec.
> > Epicor's answer to the issue is that I do get the results so there
> is
> > nothing wrong
> > Does anyone know how to resolve this issue?
> >
> > Thanks
> >
> > Motty
> >
>
11
> no, in this case I have NO links only the Customer table.
> If I create a BAQ for example for my orders and run it, I will get a
> response in 2-3 sec. for 6000 rows. if I add the customer table it
> will take 30-50 sec.
> no matter what BAQ I add the customer table or if I access it directly
> with no other joins, it always takes forever....

How long if you just create a BAQ of just the Customer table?

Mark W.
12
At least 40 seconds – I can retrieve columns from the changelog in 10
seconds and I have 250,000 entries there compared to 14,00 in the
customer table



Motty

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> > no, in this case I have NO links only the Customer table.
> > If I create a BAQ for example for my orders and run it, I will get a
> > response in 2-3 sec. for 6000 rows. if I add the customer table it
> > will take 30-50 sec.
> > no matter what BAQ I add the customer table or if I access it directly
> > with no other joins, it always takes forever....
>
> How long if you just create a BAQ of just the Customer table?
>
> Mark W.
>