new version of sqldom.sourceforge.net

I love love love this stored procedure, it allows you to spider HTML and easily parse it using SQL Server.

http://sqldom.sourceforge.net/

I’m SUPER excited to get home from work today, because there is a new version of this sproc (with better NOCOUNT) that can decrease execution time from ~60s to ~2s.

-Aaron Kempf

——————————————————————————————-
Aaron,
FYI, I posted an update to SQLDOM today on Sourceforge (.927). http://sourceforge.net/projects/sqldom/files/SQLDOM_core_927.sql/download

 

Besides adding a parameter to allow retrieving a subset of the HTML from the DOM, I found that if the caller did not have SET NOCOUNT ON that the SQLDOM procedures could run much more slowly than expected. (For example, instead of processing a page like http://www.ocregister.com in 4 seconds, it could take like 30 seconds.)

 

This version explicitly sets SET NOCOUNT ON in each procedure to avoid the risk of this condition.

 

This entry was posted in SQL Server and tagged . Bookmark the permalink.