External Epicor db query

system · February 10, 2012, 9:33am

It might also be good to note, as one of the criteria in the BAQ I have Part.PartDescription CONTAINS. This is what is slowing it down I think.

________________________________
From: tkoch77 <tkoch77@...>
To: vantage@yahoogroups.com
Sent: Friday, February 10, 2012 9:29 AM
Subject: [Vantage] External Epicor db query

Currently I have an external .Net program that is executing a BAQ and returning a dataset. As more information has been added to the database it is getting slower. I am creating a Session and using DynamicQuery BO to query the database. Is there a better way to return a dataset quicker, the BoReader works nicely but the information I want is across multiple tables.

Thanks,

-Ted

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

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

system · February 10, 2012, 9:29am

Currently I have an external .Net program that is executing a BAQ and returning a dataset. As more information has been added to the database it is getting slower. I am creating a Session and using DynamicQuery BO to query the database. Is there a better way to return a dataset quicker, the BoReader works nicely but the information I want is across multiple tables.

Thanks,

-Ted

system · February 10, 2012, 9:33am

You can use an ODBC connection to get the data and it should be faster that the BO's or WSE's.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of tkoch77
Sent: Friday, February 10, 2012 9:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] External Epicor db query

Currently I have an external .Net program that is executing a BAQ and returning a dataset. As more information has been added to the database it is getting slower. I am creating a Session and using DynamicQuery BO to query the database. Is there a better way to return a dataset quicker, the BoReader works nicely but the information I want is across multiple tables.

Thanks,

-Ted

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