Database Searching... Best Method?

[blake]

Hi,
What is the best way to go about in searching databases of alot of entries?
The entries range from 2.6 million to 9 million. We need the fastest method
to shorten our searching time. Currently it takes about 5 seconds to search
through the 2.6 million database. What is the best way to go about to get
the shortest time? Thanks!

[Robert Gelb]

Create an index on the item that you normally search by. I have a DB of 80
million entries and because of indexes, it takes less than half a second.
If possible use a stored procedure to carry out the search.

--
Robert Gelb
www.vbRad.com
Source, Tips, Tricks, Components

"blake" <flitcher@aol.com> wrote in message news:3aa14c11$1@news.devx.com...
>
> Hi,
> What is the best way to go about in searching databases of alot of
entries?
> The entries range from 2.6 million to 9 million. We need the fastest
method
> to shorten our searching time. Currently it takes about 5 seconds to
search
> through the 2.6 million database. What is the best way to go about to get
> the shortest time? Thanks!

[Blake]

Hi,
I dont know if we are on the same page here. Essentially what I have my program
do is compare our databases that are 24 hrs apart. Between those 24 hours
we delete and add new entries to the new database. Then when we are ready
to compare our databases the program will take entry number 1 in the old
database and search for it in the new database if its found it is deleted
from the new database(this keeps our speed at a constant speed)but if the
domain is found right away(which it usually is) the program "freezes" because
it is searching through all 2.6 million entries. Is there anway I can optimize
my searching to prevent the "freezing"? Thanks!
"Robert Gelb" <robertgelbNOSPAMFORME@zdnetonebox.com> wrote:
>Create an index on the item that you normally search by. I have a DB of
80
>million entries and because of indexes, it takes less than half a second.
>If possible use a stored procedure to carry out the search.
>
>--
>Robert Gelb
>www.vbRad.com
>Source, Tips, Tricks, Components
>
>"blake" <flitcher@aol.com> wrote in message news:3aa14c11$1@news.devx.com...
>>
>> Hi,
>> What is the best way to go about in searching databases of alot of
>entries?
>> The entries range from 2.6 million to 9 million. We need the fastest
>method
>> to shorten our searching time. Currently it takes about 5 seconds to
>search
>> through the 2.6 million database. What is the best way to go about to
get
>> the shortest time? Thanks!
>
>