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?*
________________________________
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]