Reply to thread

Don't have it here, it is like:

 

delete from mediaitem where miamid in (

 select miamid from provideraspect where system=@system and (path like '/resourcepath/_%' or path like '/resourcepath/>_%')

)

 

in principle a DB should be able to use the index on "path" column, because we are doing a "starts with" like query.

 

And obviously MySQL is able to do so. Not sure if MsSQL-CE can't use the index at all or that it is "only" slow because sharing process resources