Database Searching... Best Method?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Database Searching... Best Method?

  1. #1
    blake Guest

    Database Searching... Best Method?


    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!

  2. #2
    Robert Gelb Guest

    Re: Database Searching... Best Method?

    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!




  3. #3
    Blake Guest

    Re: Database Searching... Best Method?


    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!

    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center