Faster search using external program

I can see why, that really cuts down on the time to return the dataset. I'm only interested in 5 or 6 columns to display in the dataview, that was very useful.



________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Friday, November 11, 2011 3:02 PM
Subject: Re: [Vantage] Re: Faster search using external program

No prob,

I try to use that as much as I can, it cuts down on the amount of data that
is received from the BO, if you do a GetRows you are returning every Table
and child combination and its just plain slow. When most of the time all
you need is the PK and a Description.


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 11, 2011 at 2:54 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> That was it. Needed ds.tables(0) and then it worked. I was confused
> because it was returning a dataset. Thanks again for the help Jose, that
> cut the search down to less then 2 seconds.
>
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Friday, November 11, 2011 2:46 PM
>
> Subject: Re: [Vantage] Re: Faster search using external program
>
> Try this
> grid.DataSource=ds.Tables[0]
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>Â <
> http://www.facebook.com/josegomez>
>Â <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
>Â <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>Â <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Fri, Nov 11, 2011 at 2:34 PM, Jose Gomez <jose@...> wrote:
>
> > Did you step through and saw that you are getting data back?
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> >Â <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> >Â <http://www.josecgomez.com/professional-resume/> <
> http://www.josecgomez.com/feed/>
> >Â <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Fri, Nov 11, 2011 at 2:29 PM, Ted Koch <tkoch77@...> wrote:
> >
> >> **
>
> >>
> >>
> >> Ive been trying to bind this to a datagrid view but nothing happens when
> >> I do this.
> >>
> >> Dim _boReader As New BOReader(epiSession.ConnectionPool)
> >>Â Â Â Â Â Â Dim ds As DataSet = _boReader.GetList("Part",
> >> "Part.Company='100' and Part.PartNum = '" & partnum & "'Â ", "partnum")
> >>
> >>Â Â Â Â Â Â 'ComboBox1.ValueMember = "CustNum"
> >>
> >>Â Â Â Â Â Â DataGridView1.DataSource = ds
> >>
> >> Am I missing something?
> >>
> >>
> >> ________________________________
> >> From: Ted Koch <tkoch77@...>
> >> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
> >> Sent: Friday, November 11, 2011 2:07 PM
> >>
> >> Subject: Re: [Vantage] Re: Faster search using external program
> >>
> >> Found it, when i was typing in the filename box in add reference it
> wasnt
> >> showing at first.
> >>
> >> ________________________________
> >> From: Ted Koch <tkoch77@...>
> >> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
> >> Sent: Friday, November 11, 2011 2:02 PM
> >> Subject: Re: [Vantage] Re: Faster search using external program
> >>
> >> What is the path to lib.boreader and lib.iboreader. I didnt see it in
> the
> >> client folder?
> >>
> >> ________________________________
> >> From: Jose Gomez <jose@...>
> >> To: vantage@yahoogroups.com
> >> Sent: Friday, November 11, 2011 1:56 PM
> >> Subject: Re: [Vantage] Re: Faster search using external program
> >>
> >> Use the BOReader
> >>
> >> Bring in Lib.BoReader and Lib.IBOReader
> >>
> >> use it as such
> >>
> >> BOReader _boReader = new BOReader(_session.ConnectionPool);
> >>Â Â Â Â Â Â Â Â Â Â Â Â DataSet ds = _boReader.GetList("Part",
> >> "Part.Company='CO' and Part.PartNum='PNUM'",
> "Key1,Key2,Key3,Key4,Key5");
> >>
> >> Key1, key2 etc.. is a list of the fields you'd like returned.
> >>
> >> *Jose C Gomez*
> >> *Software Engineer*
> >> *
> >> *
> >> *checkout my new blog <http://www.usdoingstuff.com> *
> >> *
> >> *T: 904.469.1524 mobile
> >> E: jose@...
> >> http://www.josecgomez.com
> >> <http://www.linkedin.com/in/josecgomez>Â <
> >> http://www.facebook.com/josegomez>
> >>Â <http://www.google.com/profiles/jose.gomez> <
> >> http://www.twitter.com/joc85>
> >>Â <http://www.josecgomez.com/professional-resume/>
> >> <http://www.josecgomez.com/feed/>
> >>Â <http://www.usdoingstuff.com>
> >>
> >> *Quis custodiet ipsos custodes?*
> >>
> >> On Fri, Nov 11, 2011 at 1:53 PM, Ted Koch <tkoch77@...> wrote:
> >>
> >> > **
> >> >
> >> >
> >> > I'm running progress
> >> >
> >> > ________________________________
> >> > From: Tim Vonderhaar <tvonderhaar@...>
> >> > To: vantage@yahoogroups.com
> >> > Sent: Friday, November 11, 2011 1:51 PM
> >> > Subject: [Vantage] Re: Faster search using external program
> >> >
> >> >
> >> > Writing direct SQL queries has been a Godsend for me. I had the same
> >> > problem when I needed to read the entire Customer table. Doing it via
> >> > Service References was incredibly slow. As long as I don't need to
> >> change
> >> > data, I opt for bypassing all the layers and get the data directly.
> >> >
> >> > --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
> >> > >
> >> > > Is there any way to make an external search of the epicor database
> >> > faster? Right now I'm searching the part table and it takes probably
> >> about
> >> > 8 seconds and there are 1100 parts in there currently and that number
> >> will
> >> > always be growing.
> >> > >
> >> > > 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/.
> >> > (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]
> >> >
> >> >
> >> >
> >>
> >> [Non-text portions of this message have been removed]
> >>
> >> ------------------------------------
> >>
> >> 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/.
> >> (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]
> >>
> >> ------------------------------------
> >>
> >> 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/.
> >> (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]
> >>
> >> ------------------------------------
> >>
> >> 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/.
> >> (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]
> >>
> >>
> >>
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> 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/.
> (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]
>

>


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



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

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]
Is there any way to make an external search of the epicor database faster? Right now I'm searching the part table and it takes probably about 8 seconds and there are 1100 parts in there currently and that number will always be growing.

Thanks,

Ted
What fields are you searching on? If you can stick to the indexes, it will
help performance.

How are you searching? ODBC? Web services? How big is your result set?

On Fri, Nov 11, 2011 at 1:44 PM, tkoch77 <tkoch77@...> wrote:

> **
>
>
> Is there any way to make an external search of the epicor database faster?
> Right now I'm searching the part table and it takes probably about 8
> seconds and there are 1100 parts in there currently and that number will
> always be growing.
>
> Thanks,
>
> Ted
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
My search criteria is company and part number right now, and that returns 1 part. The whole connection is coded using epicor.mfg.core.session and blconnectionpool and the part BO.



________________________________
From: Waffqle <waffqle@...>
To: vantage@yahoogroups.com
Sent: Friday, November 11, 2011 1:45 PM
Subject: Re: [Vantage] Faster search using external program

What fields are you searching on? If you can stick to the indexes, it will
help performance.

How are you searching? ODBC? Web services? How big is your result set?

On Fri, Nov 11, 2011 at 1:44 PM, tkoch77 <tkoch77@...> wrote:

> **
>
>
> Is there any way to make an external search of the epicor database faster?
> Right now I'm searching the part table and it takes probably about 8
> seconds and there are 1100 parts in there currently and that number will
> always be growing.
>
> Thanks,
>
> Ted
>

>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


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



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

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]
Writing direct SQL queries has been a Godsend for me. I had the same problem when I needed to read the entire Customer table. Doing it via Service References was incredibly slow. As long as I don't need to change data, I opt for bypassing all the layers and get the data directly.

--- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>
> Is there any way to make an external search of the epicor database faster? Right now I'm searching the part table and it takes probably about 8 seconds and there are 1100 parts in there currently and that number will always be growing.
>
> Thanks,
>
> Ted
>
I'm running progress



________________________________
From: Tim Vonderhaar <tvonderhaar@...>
To: vantage@yahoogroups.com
Sent: Friday, November 11, 2011 1:51 PM
Subject: [Vantage] Re: Faster search using external program

Writing direct SQL queries has been a Godsend for me. I had the same problem when I needed to read the entire Customer table. Doing it via Service References was incredibly slow. As long as I don't need to change data, I opt for bypassing all the layers and get the data directly.

--- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>
> Is there any way to make an external search of the epicor database faster? Right now I'm searching the part table and it takes probably about 8 seconds and there are 1100 parts in there currently and that number will always be growing.
>
> 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]
Use the BOReader

Bring in Lib.BoReader and Lib.IBOReader

use it as such

BOReader _boReader = new BOReader(_session.ConnectionPool);
DataSet ds = _boReader.GetList("Part",
"Part.Company='CO' and Part.PartNum='PNUM'", "Key1,Key2,Key3,Key4,Key5");

Key1, key2 etc.. is a list of the fields you'd like returned.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 11, 2011 at 1:53 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> I'm running progress
>
> ________________________________
> From: Tim Vonderhaar <tvonderhaar@...>
> To: vantage@yahoogroups.com
> Sent: Friday, November 11, 2011 1:51 PM
> Subject: [Vantage] Re: Faster search using external program
>
>
> Writing direct SQL queries has been a Godsend for me. I had the same
> problem when I needed to read the entire Customer table. Doing it via
> Service References was incredibly slow. As long as I don't need to change
> data, I opt for bypassing all the layers and get the data directly.
>
> --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
> >
> > Is there any way to make an external search of the epicor database
> faster? Right now I'm searching the part table and it takes probably about
> 8 seconds and there are 1100 parts in there currently and that number will
> always be growing.
> >
> > 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/.
> (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]
>
>
>


[Non-text portions of this message have been removed]
What is the path to lib.boreader and lib.iboreader. I didnt see it in the client folder?



________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Friday, November 11, 2011 1:56 PM
Subject: Re: [Vantage] Re: Faster search using external program

Use the BOReader

Bring in Lib.BoReader and Lib.IBOReader

use it as such

BOReader _boReader = new BOReader(_session.ConnectionPool);
            DataSet ds = _boReader.GetList("Part",
"Part.Company='CO' and Part.PartNum='PNUM'", "Key1,Key2,Key3,Key4,Key5");

Key1, key2 etc.. is a list of the fields you'd like returned.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 11, 2011 at 1:53 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> I'm running progress
>
> ________________________________
> From: Tim Vonderhaar <tvonderhaar@...>
> To: vantage@yahoogroups.com
> Sent: Friday, November 11, 2011 1:51 PM
> Subject: [Vantage] Re: Faster search using external program
>
>
> Writing direct SQL queries has been a Godsend for me. I had the same
> problem when I needed to read the entire Customer table. Doing it via
> Service References was incredibly slow. As long as I don't need to change
> data, I opt for bypassing all the layers and get the data directly.
>
> --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
> >
> > Is there any way to make an external search of the epicor database
> faster? Right now I'm searching the part table and it takes probably about
> 8 seconds and there are 1100 parts in there currently and that number will
> always be growing.
> >
> > 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/.
> (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]
>

>


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



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

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]
Found it, when i was typing in the filename box in add reference it wasnt showing at first.



________________________________
From: Ted Koch <tkoch77@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, November 11, 2011 2:02 PM
Subject: Re: [Vantage] Re: Faster search using external program

What is the path to lib.boreader and lib.iboreader. I didnt see it in the client folder?



________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Friday, November 11, 2011 1:56 PM
Subject: Re: [Vantage] Re: Faster search using external program

Use the BOReader

Bring in Lib.BoReader and Lib.IBOReader

use it as such

BOReader _boReader = new BOReader(_session.ConnectionPool);
            DataSet ds = _boReader.GetList("Part",
"Part.Company='CO' and Part.PartNum='PNUM'", "Key1,Key2,Key3,Key4,Key5");

Key1, key2 etc.. is a list of the fields you'd like returned.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 11, 2011 at 1:53 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> I'm running progress
>
> ________________________________
> From: Tim Vonderhaar <tvonderhaar@...>
> To: vantage@yahoogroups.com
> Sent: Friday, November 11, 2011 1:51 PM
> Subject: [Vantage] Re: Faster search using external program
>
>
> Writing direct SQL queries has been a Godsend for me. I had the same
> problem when I needed to read the entire Customer table. Doing it via
> Service References was incredibly slow. As long as I don't need to change
> data, I opt for bypassing all the layers and get the data directly.
>
> --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
> >
> > Is there any way to make an external search of the epicor database
> faster? Right now I'm searching the part table and it takes probably about
> 8 seconds and there are 1100 parts in there currently and that number will
> always be growing.
> >
> > 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/.
> (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]
>

>


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



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

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]



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

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]
Ive been trying to bind this to a datagrid view but nothing happens when I do this.

Dim _boReader As New BOReader(epiSession.ConnectionPool)
           Dim ds As DataSet = _boReader.GetList("Part", "Part.Company='100' and Part.PartNum = '" & partnum & "' ", "partnum")

           'ComboBox1.ValueMember = "CustNum"

           DataGridView1.DataSource = ds

Am I missing something?



________________________________
From: Ted Koch <tkoch77@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, November 11, 2011 2:07 PM
Subject: Re: [Vantage] Re: Faster search using external program

Found it, when i was typing in the filename box in add reference it wasnt showing at first.



________________________________
From: Ted Koch <tkoch77@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, November 11, 2011 2:02 PM
Subject: Re: [Vantage] Re: Faster search using external program

What is the path to lib.boreader and lib.iboreader. I didnt see it in the client folder?



________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Friday, November 11, 2011 1:56 PM
Subject: Re: [Vantage] Re: Faster search using external program

Use the BOReader

Bring in Lib.BoReader and Lib.IBOReader

use it as such

BOReader _boReader = new BOReader(_session.ConnectionPool);
            DataSet ds = _boReader.GetList("Part",
"Part.Company='CO' and Part.PartNum='PNUM'", "Key1,Key2,Key3,Key4,Key5");

Key1, key2 etc.. is a list of the fields you'd like returned.

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 11, 2011 at 1:53 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> I'm running progress
>
> ________________________________
> From: Tim Vonderhaar <tvonderhaar@...>
> To: vantage@yahoogroups.com
> Sent: Friday, November 11, 2011 1:51 PM
> Subject: [Vantage] Re: Faster search using external program
>
>
> Writing direct SQL queries has been a Godsend for me. I had the same
> problem when I needed to read the entire Customer table. Doing it via
> Service References was incredibly slow. As long as I don't need to change
> data, I opt for bypassing all the layers and get the data directly.
>
> --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
> >
> > Is there any way to make an external search of the epicor database
> faster? Right now I'm searching the part table and it takes probably about
> 8 seconds and there are 1100 parts in there currently and that number will
> always be growing.
> >
> > 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/.
> (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]
>

>


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



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

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]



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

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]



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

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]
Did you step through and saw that you are getting data back?

*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 11, 2011 at 2:29 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> Ive been trying to bind this to a datagrid view but nothing happens when I
> do this.
>
> Dim _boReader As New BOReader(epiSession.ConnectionPool)
> Dim ds As DataSet = _boReader.GetList("Part",
> "Part.Company='100' and Part.PartNum = '" & partnum & "' ", "partnum")
>
> 'ComboBox1.ValueMember = "CustNum"
>
> DataGridView1.DataSource = ds
>
> Am I missing something?
>
>
> ________________________________
> From: Ted Koch <tkoch77@...>
> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
> Sent: Friday, November 11, 2011 2:07 PM
>
> Subject: Re: [Vantage] Re: Faster search using external program
>
> Found it, when i was typing in the filename box in add reference it wasnt
> showing at first.
>
> ________________________________
> From: Ted Koch <tkoch77@...>
> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
> Sent: Friday, November 11, 2011 2:02 PM
> Subject: Re: [Vantage] Re: Faster search using external program
>
> What is the path to lib.boreader and lib.iboreader. I didnt see it in the
> client folder?
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Friday, November 11, 2011 1:56 PM
> Subject: Re: [Vantage] Re: Faster search using external program
>
> Use the BOReader
>
> Bring in Lib.BoReader and Lib.IBOReader
>
> use it as such
>
> BOReader _boReader = new BOReader(_session.ConnectionPool);
> DataSet ds = _boReader.GetList("Part",
> "Part.Company='CO' and Part.PartNum='PNUM'", "Key1,Key2,Key3,Key4,Key5");
>
> Key1, key2 etc.. is a list of the fields you'd like returned.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Fri, Nov 11, 2011 at 1:53 PM, Ted Koch <tkoch77@...> wrote:
>
> > **
> >
> >
> > I'm running progress
> >
> > ________________________________
> > From: Tim Vonderhaar <tvonderhaar@...>
> > To: vantage@yahoogroups.com
> > Sent: Friday, November 11, 2011 1:51 PM
> > Subject: [Vantage] Re: Faster search using external program
> >
> >
> > Writing direct SQL queries has been a Godsend for me. I had the same
> > problem when I needed to read the entire Customer table. Doing it via
> > Service References was incredibly slow. As long as I don't need to
> change
> > data, I opt for bypassing all the layers and get the data directly.
> >
> > --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
> > >
> > > Is there any way to make an external search of the epicor database
> > faster? Right now I'm searching the part table and it takes probably
> about
> > 8 seconds and there are 1100 parts in there currently and that number
> will
> > always be growing.
> > >
> > > 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/.
> > (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]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> 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/.
> (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]
>
> ------------------------------------
>
> 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/.
> (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]
>
> ------------------------------------
>
> 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/.
> (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]
>
>
>


[Non-text portions of this message have been removed]
Try this
grid.DataSource=ds.Tables[0]


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 11, 2011 at 2:34 PM, Jose Gomez <jose@...> wrote:

> Did you step through and saw that you are getting data back?
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Fri, Nov 11, 2011 at 2:29 PM, Ted Koch <tkoch77@...> wrote:
>
>> **
>>
>>
>> Ive been trying to bind this to a datagrid view but nothing happens when
>> I do this.
>>
>> Dim _boReader As New BOReader(epiSession.ConnectionPool)
>> Dim ds As DataSet = _boReader.GetList("Part",
>> "Part.Company='100' and Part.PartNum = '" & partnum & "' ", "partnum")
>>
>> 'ComboBox1.ValueMember = "CustNum"
>>
>> DataGridView1.DataSource = ds
>>
>> Am I missing something?
>>
>>
>> ________________________________
>> From: Ted Koch <tkoch77@...>
>> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
>> Sent: Friday, November 11, 2011 2:07 PM
>>
>> Subject: Re: [Vantage] Re: Faster search using external program
>>
>> Found it, when i was typing in the filename box in add reference it wasnt
>> showing at first.
>>
>> ________________________________
>> From: Ted Koch <tkoch77@...>
>> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
>> Sent: Friday, November 11, 2011 2:02 PM
>> Subject: Re: [Vantage] Re: Faster search using external program
>>
>> What is the path to lib.boreader and lib.iboreader. I didnt see it in the
>> client folder?
>>
>> ________________________________
>> From: Jose Gomez <jose@...>
>> To: vantage@yahoogroups.com
>> Sent: Friday, November 11, 2011 1:56 PM
>> Subject: Re: [Vantage] Re: Faster search using external program
>>
>> Use the BOReader
>>
>> Bring in Lib.BoReader and Lib.IBOReader
>>
>> use it as such
>>
>> BOReader _boReader = new BOReader(_session.ConnectionPool);
>> DataSet ds = _boReader.GetList("Part",
>> "Part.Company='CO' and Part.PartNum='PNUM'", "Key1,Key2,Key3,Key4,Key5");
>>
>> Key1, key2 etc.. is a list of the fields you'd like returned.
>>
>> *Jose C Gomez*
>> *Software Engineer*
>> *
>> *
>> *checkout my new blog <http://www.usdoingstuff.com> *
>> *
>> *T: 904.469.1524 mobile
>> E: jose@...
>> http://www.josecgomez.com
>> <http://www.linkedin.com/in/josecgomez> <
>> http://www.facebook.com/josegomez>
>> <http://www.google.com/profiles/jose.gomez> <
>> http://www.twitter.com/joc85>
>> <http://www.josecgomez.com/professional-resume/>
>> <http://www.josecgomez.com/feed/>
>> <http://www.usdoingstuff.com>
>>
>> *Quis custodiet ipsos custodes?*
>>
>> On Fri, Nov 11, 2011 at 1:53 PM, Ted Koch <tkoch77@...> wrote:
>>
>> > **
>> >
>> >
>> > I'm running progress
>> >
>> > ________________________________
>> > From: Tim Vonderhaar <tvonderhaar@...>
>> > To: vantage@yahoogroups.com
>> > Sent: Friday, November 11, 2011 1:51 PM
>> > Subject: [Vantage] Re: Faster search using external program
>> >
>> >
>> > Writing direct SQL queries has been a Godsend for me. I had the same
>> > problem when I needed to read the entire Customer table. Doing it via
>> > Service References was incredibly slow. As long as I don't need to
>> change
>> > data, I opt for bypassing all the layers and get the data directly.
>> >
>> > --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>> > >
>> > > Is there any way to make an external search of the epicor database
>> > faster? Right now I'm searching the part table and it takes probably
>> about
>> > 8 seconds and there are 1100 parts in there currently and that number
>> will
>> > always be growing.
>> > >
>> > > 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/.
>> > (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]
>> >
>> >
>> >
>>
>> [Non-text portions of this message have been removed]
>>
>> ------------------------------------
>>
>> 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/.
>> (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]
>>
>> ------------------------------------
>>
>> 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/.
>> (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]
>>
>> ------------------------------------
>>
>> 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/.
>> (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]
>>
>>
>>
>
>


[Non-text portions of this message have been removed]
That was it. Needed ds.tables(0) and then it worked. I was confused because it was returning a dataset. Thanks again for the help Jose, that cut the search down to less then 2 seconds.



________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Friday, November 11, 2011 2:46 PM
Subject: Re: [Vantage] Re: Faster search using external program

Try this
grid.DataSource=ds.Tables[0]


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
 <http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 11, 2011 at 2:34 PM, Jose Gomez <jose@...> wrote:

> Did you step through and saw that you are getting data back?
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
>Â <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
>Â <http://www.josecgomez.com/professional-resume/> <http://www.josecgomez.com/feed/>
>Â <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Fri, Nov 11, 2011 at 2:29 PM, Ted Koch <tkoch77@...> wrote:
>
>> **
>>
>>
>> Ive been trying to bind this to a datagrid view but nothing happens when
>> I do this.
>>
>> Dim _boReader As New BOReader(epiSession.ConnectionPool)
>>Â Â Â Â Â Â Dim ds As DataSet = _boReader.GetList("Part",
>> "Part.Company='100' and Part.PartNum = '" & partnum & "'Â ", "partnum")
>>
>>Â Â Â Â Â Â 'ComboBox1.ValueMember = "CustNum"
>>
>>Â Â Â Â Â Â DataGridView1.DataSource = ds
>>
>> Am I missing something?
>>
>>
>> ________________________________
>> From: Ted Koch <tkoch77@...>
>> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
>> Sent: Friday, November 11, 2011 2:07 PM
>>
>> Subject: Re: [Vantage] Re: Faster search using external program
>>
>> Found it, when i was typing in the filename box in add reference it wasnt
>> showing at first.
>>
>> ________________________________
>> From: Ted Koch <tkoch77@...>
>> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
>> Sent: Friday, November 11, 2011 2:02 PM
>> Subject: Re: [Vantage] Re: Faster search using external program
>>
>> What is the path to lib.boreader and lib.iboreader. I didnt see it in the
>> client folder?
>>
>> ________________________________
>> From: Jose Gomez <jose@...>
>> To: vantage@yahoogroups.com
>> Sent: Friday, November 11, 2011 1:56 PM
>> Subject: Re: [Vantage] Re: Faster search using external program
>>
>> Use the BOReader
>>
>> Bring in Lib.BoReader and Lib.IBOReader
>>
>> use it as such
>>
>> BOReader _boReader = new BOReader(_session.ConnectionPool);
>>Â Â Â Â Â Â Â Â Â Â Â Â DataSet ds = _boReader.GetList("Part",
>> "Part.Company='CO' and Part.PartNum='PNUM'", "Key1,Key2,Key3,Key4,Key5");
>>
>> Key1, key2 etc.. is a list of the fields you'd like returned.
>>
>> *Jose C Gomez*
>> *Software Engineer*
>> *
>> *
>> *checkout my new blog <http://www.usdoingstuff.com> *
>> *
>> *T: 904.469.1524 mobile
>> E: jose@...
>> http://www.josecgomez.com
>> <http://www.linkedin.com/in/josecgomez>Â <
>> http://www.facebook.com/josegomez>
>>Â <http://www.google.com/profiles/jose.gomez> <
>> http://www.twitter.com/joc85>
>>Â <http://www.josecgomez.com/professional-resume/>
>> <http://www.josecgomez.com/feed/>
>>Â <http://www.usdoingstuff.com>
>>
>> *Quis custodiet ipsos custodes?*
>>
>> On Fri, Nov 11, 2011 at 1:53 PM, Ted Koch <tkoch77@...> wrote:
>>
>> > **
>> >
>> >
>> > I'm running progress
>> >
>> > ________________________________
>> > From: Tim Vonderhaar <tvonderhaar@...>
>> > To: vantage@yahoogroups.com
>> > Sent: Friday, November 11, 2011 1:51 PM
>> > Subject: [Vantage] Re: Faster search using external program
>> >
>> >
>> > Writing direct SQL queries has been a Godsend for me. I had the same
>> > problem when I needed to read the entire Customer table. Doing it via
>> > Service References was incredibly slow. As long as I don't need to
>> change
>> > data, I opt for bypassing all the layers and get the data directly.
>> >
>> > --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
>> > >
>> > > Is there any way to make an external search of the epicor database
>> > faster? Right now I'm searching the part table and it takes probably
>> about
>> > 8 seconds and there are 1100 parts in there currently and that number
>> will
>> > always be growing.
>> > >
>> > > 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/.
>> > (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]
>> >
>> >
>> >
>>
>> [Non-text portions of this message have been removed]
>>
>> ------------------------------------
>>
>> 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/.
>> (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]
>>
>> ------------------------------------
>>
>> 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/.
>> (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]
>>
>> ------------------------------------
>>
>> 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/.
>> (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]
>>
>>Â
>>
>
>


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



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

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]
No prob,

I try to use that as much as I can, it cuts down on the amount of data that
is received from the BO, if you do a GetRows you are returning every Table
and child combination and its just plain slow. When most of the time all
you need is the PK and a Description.


*Jose C Gomez*
*Software Engineer*
*
*
*checkout my new blog <http://www.usdoingstuff.com> *
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Fri, Nov 11, 2011 at 2:54 PM, Ted Koch <tkoch77@...> wrote:

> **
>
>
> That was it. Needed ds.tables(0) and then it worked. I was confused
> because it was returning a dataset. Thanks again for the help Jose, that
> cut the search down to less then 2 seconds.
>
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Friday, November 11, 2011 2:46 PM
>
> Subject: Re: [Vantage] Re: Faster search using external program
>
> Try this
> grid.DataSource=ds.Tables[0]
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
> On Fri, Nov 11, 2011 at 2:34 PM, Jose Gomez <jose@...> wrote:
>
> > Did you step through and saw that you are getting data back?
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *checkout my new blog <http://www.usdoingstuff.com> *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/> <
> http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Fri, Nov 11, 2011 at 2:29 PM, Ted Koch <tkoch77@...> wrote:
> >
> >> **
>
> >>
> >>
> >> Ive been trying to bind this to a datagrid view but nothing happens when
> >> I do this.
> >>
> >> Dim _boReader As New BOReader(epiSession.ConnectionPool)
> >> Dim ds As DataSet = _boReader.GetList("Part",
> >> "Part.Company='100' and Part.PartNum = '" & partnum & "' ", "partnum")
> >>
> >> 'ComboBox1.ValueMember = "CustNum"
> >>
> >> DataGridView1.DataSource = ds
> >>
> >> Am I missing something?
> >>
> >>
> >> ________________________________
> >> From: Ted Koch <tkoch77@...>
> >> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
> >> Sent: Friday, November 11, 2011 2:07 PM
> >>
> >> Subject: Re: [Vantage] Re: Faster search using external program
> >>
> >> Found it, when i was typing in the filename box in add reference it
> wasnt
> >> showing at first.
> >>
> >> ________________________________
> >> From: Ted Koch <tkoch77@...>
> >> To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
> >> Sent: Friday, November 11, 2011 2:02 PM
> >> Subject: Re: [Vantage] Re: Faster search using external program
> >>
> >> What is the path to lib.boreader and lib.iboreader. I didnt see it in
> the
> >> client folder?
> >>
> >> ________________________________
> >> From: Jose Gomez <jose@...>
> >> To: vantage@yahoogroups.com
> >> Sent: Friday, November 11, 2011 1:56 PM
> >> Subject: Re: [Vantage] Re: Faster search using external program
> >>
> >> Use the BOReader
> >>
> >> Bring in Lib.BoReader and Lib.IBOReader
> >>
> >> use it as such
> >>
> >> BOReader _boReader = new BOReader(_session.ConnectionPool);
> >> DataSet ds = _boReader.GetList("Part",
> >> "Part.Company='CO' and Part.PartNum='PNUM'",
> "Key1,Key2,Key3,Key4,Key5");
> >>
> >> Key1, key2 etc.. is a list of the fields you'd like returned.
> >>
> >> *Jose C Gomez*
> >> *Software Engineer*
> >> *
> >> *
> >> *checkout my new blog <http://www.usdoingstuff.com> *
> >> *
> >> *T: 904.469.1524 mobile
> >> E: jose@...
> >> http://www.josecgomez.com
> >> <http://www.linkedin.com/in/josecgomez> <
> >> http://www.facebook.com/josegomez>
> >> <http://www.google.com/profiles/jose.gomez> <
> >> http://www.twitter.com/joc85>
> >> <http://www.josecgomez.com/professional-resume/>
> >> <http://www.josecgomez.com/feed/>
> >> <http://www.usdoingstuff.com>
> >>
> >> *Quis custodiet ipsos custodes?*
> >>
> >> On Fri, Nov 11, 2011 at 1:53 PM, Ted Koch <tkoch77@...> wrote:
> >>
> >> > **
> >> >
> >> >
> >> > I'm running progress
> >> >
> >> > ________________________________
> >> > From: Tim Vonderhaar <tvonderhaar@...>
> >> > To: vantage@yahoogroups.com
> >> > Sent: Friday, November 11, 2011 1:51 PM
> >> > Subject: [Vantage] Re: Faster search using external program
> >> >
> >> >
> >> > Writing direct SQL queries has been a Godsend for me. I had the same
> >> > problem when I needed to read the entire Customer table. Doing it via
> >> > Service References was incredibly slow. As long as I don't need to
> >> change
> >> > data, I opt for bypassing all the layers and get the data directly.
> >> >
> >> > --- In vantage@yahoogroups.com, "tkoch77" <tkoch77@...> wrote:
> >> > >
> >> > > Is there any way to make an external search of the epicor database
> >> > faster? Right now I'm searching the part table and it takes probably
> >> about
> >> > 8 seconds and there are 1100 parts in there currently and that number
> >> will
> >> > always be growing.
> >> > >
> >> > > 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/.
> >> > (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]
> >> >
> >> >
> >> >
> >>
> >> [Non-text portions of this message have been removed]
> >>
> >> ------------------------------------
> >>
> >> 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/.
> >> (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]
> >>
> >> ------------------------------------
> >>
> >> 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/.
> >> (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]
> >>
> >> ------------------------------------
> >>
> >> 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/.
> >> (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]
> >>
> >>
> >>
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> 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/.
> (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]
>
>
>


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