|
Posted by Steven Ickman [MSFT] on July 12, 2005, 5:19 am
Please log in for more thread options
Sean,
I looked a little closer at your implementation and one comment I'd make is
that you're probably running more queries then you need to in your OnLoad()
method. The query for LoadGenres() is going to return every music item you
have and the OleDbDataAdapter.Fill() method is going to touch everyone of
those items as it selectively copies values into your DataSet. That means
any additional queries are wasted cycles.
If you were ok with keeping some stuff in memory you could probably work out
a way to build all of your Genre, Artist, and Album info using a single query
and then re-query for album tracks as needed. Just a thought...
-Steve
"Steven Ickman [MSFT]" wrote:
> Hey Sean,
>
> I saw the update...
>
> To answer your questions:
>
> 1. Not at this time. It's already came up as a feature request though.
>
> 2. Yes, I'm 95% certain new columns get added to the index as the crawler
> encounters them. My 5% uncertainty comes from the fact that I know the
> indexer supports this capability but we may have it disabled. No matter
> what, I can tell you with 100% certainty that the UI will not detect these
> new columns. The UI is currently driven by a schema that works independantly
> of the indexer so it can only surface known columns. It's also worth noting
> that since I don't think this is an advertised feature it may stop working at
> anytime.
>
> -Steve
>
> "Sean McLeod" wrote:
>
> > I've updated my CodeProject article to mention the updated SDK and added a
> > link to your blog posting for more details. If I get a Media Center version
> > running I'll definitely post back here.
> >
> > A couple of questions:
> >
> > 1. Is there a better way to get a list of distinct/unique categories like
> > MusicGenre than the method I used?
> >
> > 2. Are new columns added to the index if an IFilter component is added that
> > returns new properties that currently aren't in the current list of columns?
> > For example if I install an image IFilter that indexes additional EXIF
> > and/or IPTC properties will these automatically show up as additional
> > columns that can be queried on and returned in the resultset?
> >
> > Cheers
> >
> >
> > > Awsome job Sean!
> > >
> > > You may not have noticed but we just posted an updated SDK containing
> > > pre-built interop assemblies along with a .NET sample. Not that you
> > > apparently need them. :)
> > >
> > > http://addins.msn.com/support/WDSSDK.zip
> > > http://addins.msn.com/support/WDSSample.zip
> > >
> > > I also posted some additional comments about using the new API's on my
> > > blog:
> > >
> > >
http://spaces.msn.com/members/wdstech/Blog/cns!1p0tYOH23YIjQaVyUIcoDDIA!146.entry
> > >
> > > Be sure and post back here if you end up building a Media Center add-in.
> > > I'd love to check it out. Again, great work!
> > >
> > > -Steve
> > >
> >
> >
> >
| 
XML Sitemap