SQL Server Performance

Surfray : Speed Index

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by deepakontheweb, Jan 29, 2007.

  1. deepakontheweb New Member

    Just 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
    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.
  2. thomas New Member

    It looks like it's for xml indexes only? the 1800 times faster claims refers to xml indexes.
  3. deepakontheweb New Member

    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">
  4. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    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.
  5. MohammedU New Member

    My understanding is only compared with XML and FULL TEXT indexes but not the regular index.

    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page