SQL Server Performance Forum – Threads Archive
Surfray : Speed IndexJust Curious because it look intresting to have 1800 times faster index search, has somebody noticed and used speed index described in below links [?][?]
I am not able to find more technical details about it:
http://www.surfray.com/en/index.php/products/technical_information/1800_times_faster [8D] Deepak Kumar
MVP, MCDBA – SQL Server Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.
It looks like it’s for xml indexes only? the 1800 times faster claims refers to xml indexes.
its not clear that its only for XML, no technical info.. <img src=’/community/emoticons/emotion-6.gif’ alt=’‘ /><br /><br /><br />From:<a target="_blank" href=http://www.surfray.com/en/index.php/products/overloook>http://www.surfray.com/en/index.php/products/overloook</a><br /><br />Searches up to 1800 times faster than Microsoft SQL Server 2005 and 40 times faster than Oracle Text <br />Direct integration with enterprise databases ensures real real-time index updating. <br />Unlike products such as Oracle Text and IBM Excalibur, SurfRay Multi-level Indexing ensures full simultaneity in indexing and searching, and users experience no performance degradation whatsoever during indexing. <br /><br />From:<a target="_blank" href=http://www.surfray.com/en/index.php/products/technical_information/1800_times_faster>http://www.surfray.com/en/index.php/products/technical_information/1800_times_faster</a><br /><br />Ordered Results Performance<br />Another highly significant result is that the top 10, most recent results, when ordered by date or any other number, is retrieved approximately 830 times faster using Speed Index, compared to the SQL Server XML Index.<br /><br /><b>Deepak Kumar</b><br /><font size="1">MVP, MCDBA – SQL Server<br /><br />Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.</font id="size1">
Have you contacted the Vendor in this case and they must be tested before taking it granted. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
My understanding is only compared with XML and FULL TEXT indexes but not the regular index. MohammedU.