SQL Server Performance

Table Exploding

Discussion in 'ALL SQL SERVER QUESTIONS' started by Hrishi_nk, Dec 18, 2012.

  1. Hrishi_nk New Member

    Hi Experts,
    I have a table which stores domain and its url s .All the urls in the table are distinct.I have a column which stores md5 hash of that url and have a nonclustered index on md5 hash.
    The problem is the distinct urls which are inserted in this table are very high in number.The table already has 100 million urls.We are also using this table for reporting.It also cannot be partitioned(as on what basis should it be partitioned).
    The table structure is somewhat like this
    id bigint ,domain_name varchar,url nvarchar(max),md5_hash varchar
    Can this data be stored more efficiently as querying such a large table takes a lot of time.
    Any advice will be highly appreciated
  2. FrankKalis Moderator

    Welcome to the forum!
    The decision on how to store the data is a fundamental decision is the whole application design process. We know far too little about the whole requirements to suggest anything useful.

    Depending on what your reporting requirements are, if might be worth transferring the data to some kind of datawarehousing data storage.

Share This Page