June 9, 2003 at 9:46 am
Can someone will give me some hints in searching millions and billions of record very fast.
any suggestion would be highly appreciated.
June 9, 2003 at 10:00 am
It depends on what kind of data you have in your rows. Is it numeric, character, text, etc? Are you talking about data in one table or you need to join? In any case you woudl need to implement proper indexes and keep those refreshed when data is updates. But remember: your queries must be written in a way that allows to take advantage of the indexes. Clustered index is the fastest for searches, of course. Sometimes it mayt hurt performance of updates. Use FILLFACTOR and periodic rebuilds on the index to overcome this problem.
Generally speaking, it is a broad topic one could write a book on.
June 10, 2003 at 6:06 am
Hello nafshan,
quote:
Can someone will give me some hints in searching millions and billions of record very fast.
if you can estimate your db will contain that much records, I agree with mromm that one can write a book on how to get maximum performance. It starts with hardware, moves over to software (OS, Webserver, SQL Server), then db design (table design, indexes...) and ends with the GUI stuff.
Can you give more information on what you are searching for?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply