Search performance

Not sure what version you are on, but this was fixed in 8.03.408A. What I did
until this version was to create my own BAQ search and made it the default for
report maintenance.




________________________________
From: Chris Thompson <chriselectrix@...>
To: vantage@yahoogroups.com
Sent: Thu, September 16, 2010 12:00:49 PM
Subject: Re: [Vantage] Search performance

Â
Report maintenance does take ages - I have this logged as a support call. Mine
takes over 1min.

What are the times like for e.g. searching for a customer or quote/ordeR?

________________________________
From: Joel Kolling <jkolling@...>
To: vantage@yahoogroups.com
Sent: Thu, 16 September, 2010 16:49:00
Subject: RE: [Vantage] Search performance

Â
For example searching in Report Maintenance for Report ID takes 35 Seconds.
Doing Next 100 takes about as long. This contains only 158 records.

Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Thursday, September 16, 2010 12:23 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Search performance

Hi Joel

What do you class as 'ages'?

Please provide some examples.

________________________________
From: Joel Kolling <jkolling@... <mailto:jkolling%40itcmfg.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wed, 15 September, 2010 0:34:35
Subject: [Vantage] Search performance

When we do searches it is taking forever. This is on any search we do.
Anyone know what the issue may be? Our DB is 3.5gb and our server is
plenty big enough. 16gb ram, Dual Quad core 3.0ghz.

Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
When we do searches it is taking forever. This is on any search we do.
Anyone know what the issue may be? Our DB is 3.5gb and our server is
plenty big enough. 16gb ram, Dual Quad core 3.0ghz.



Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444


[Non-text portions of this message have been removed]
Hi Joel

What do you class as 'ages'?

Please provide some examples.




________________________________
From: Joel Kolling <jkolling@...>
To: vantage@yahoogroups.com
Sent: Wed, 15 September, 2010 0:34:35
Subject: [Vantage] Search performance

Â
When we do searches it is taking forever. This is on any search we do.
Anyone know what the issue may be? Our DB is 3.5gb and our server is
plenty big enough. 16gb ram, Dual Quad core 3.0ghz.



Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
For example searching in Report Maintenance for Report ID takes 35 Seconds. Doing Next 100 takes about as long. This contains only 158 records.



Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Thursday, September 16, 2010 12:23 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Search performance


Hi Joel

What do you class as 'ages'?

Please provide some examples.

________________________________
From: Joel Kolling <jkolling@... <mailto:jkolling%40itcmfg.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wed, 15 September, 2010 0:34:35
Subject: [Vantage] Search performance


When we do searches it is taking forever. This is on any search we do.
Anyone know what the issue may be? Our DB is 3.5gb and our server is
plenty big enough. 16gb ram, Dual Quad core 3.0ghz.

Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
Report maintenance does take ages - I have this logged as a support call. Mine
takes over 1min.

What are the times like for e.g. searching for a customer or quote/ordeR?




________________________________
From: Joel Kolling <jkolling@...>
To: vantage@yahoogroups.com
Sent: Thu, 16 September, 2010 16:49:00
Subject: RE: [Vantage] Search performance

Â
For example searching in Report Maintenance for Report ID takes 35 Seconds.
Doing Next 100 takes about as long. This contains only 158 records.




Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Thursday, September 16, 2010 12:23 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Search performance


Hi Joel

What do you class as 'ages'?

Please provide some examples.

________________________________
From: Joel Kolling <jkolling@... <mailto:jkolling%40itcmfg.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wed, 15 September, 2010 0:34:35
Subject: [Vantage] Search performance


When we do searches it is taking forever. This is on any search we do.
Anyone know what the issue may be? Our DB is 3.5gb and our server is
plenty big enough. 16gb ram, Dual Quad core 3.0ghz.

Joel Kolling
IT Manager
ITC Manufacturing, Inc.
Phone: 602-648-0021
Cell: 480-861-2009
Fax: 602-415-1444

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]


[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]