Re: Is there any REGEXP library for TSQL?




"Martijn Tonies" <m.tonies@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:11mhdiekuhe26e9@xxxxxxxxxxxxxxxxxxxxx
> > >> In SQL 2005, there is no better support in T-SQL, but you can call a
> CLR
> > >> routine that uses the RegEx classes in .Net.
> > >
> > > I guess for SQL 2000, you could use a non-COM library as an "extended
> > > procedure"?
> >
> > But performance would be awful and the code would be messy.
>
> I've never written any extended procedures, so perhaps you could
> explain why this would give awful performance?
>
> I imagine the call could be as:
>
> select ...
> from ...
> where myregexp_match(mycolumn, myexpression, myvalue)
>
> Why would this be any slower than COM or .NET? Isn't this partly
> what extended procedures were meant for?
>

I'm guessing the main reason is that in SQL 2000, it executes outside of SQL
Server, which means for every call there's delay as it has to call out of
its address space. SQL 2005 CLR code executes within the same memory space
as SQL Server.


>
> --
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>


.



Relevant Pages

  • Re: Performance is slow when calling web services in SQL CLR
    ... I have done async before, but not with sql clr sp. ... We have SQL CLR stored procedures that call web services. ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance is slow when calling web services in SQL CLR
    ... I do this on each call of the Clr routine. ... Lastly - do we need to set this property whenever we use web services, not just in sql clr sp? ... We have SQL CLR stored procedures that call web services. ... When the web service calls take long then it affects the performance of SQL DB of that sp completely, and slows down other CLR stored procedures. ...
    (microsoft.public.sqlserver.programming)
  • RE: DTS is blocked by XP
    ... When usung XP (extended procedures), the login you use to access the SQL ... server instance will require permissions within to run extended procedures. ... Look for setting permissiones in SQL. ...
    (microsoft.public.sqlserver.dts)
  • Re: Sequential Number in an Update
    ... among Standard SQL, ... Like I said again - how would you code this NOW in SQL Server; ... You've already told us "NO CLR, ... having a Mail Exchanger ius not a problem for all the sites that are ...
    (comp.databases.ms-sqlserver)
  • Re: Performance is slow when calling web services in SQL CLR
    ... do not even call CLR from within the TSQL action that wishes ... SQL Server MVP ... We have SQL CLR stored procedures that call web services. ... When the web service calls take long then it ...
    (microsoft.public.sqlserver.programming)