Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2011
    Location
    india- new delhi
    Posts
    31

    Unanswered: area to work out for fast searching from database?

    if we create dynamic application where on a click , on a text box value we need to search related content from database, and my database is huge,
    1-can anybody tell me about those areas where i need to focus for fast searching... which concept i should use for this,
    2- for respect of fast sarching which area are responsible like- how u create table, how u query and all that..
    3- fast searching is depend on what?
    ...........................just help me and only give me guidline with help of that i can learn good concept of database and implement it to make efficient database..
    Amit Pathak
    S/w Developer
    Zero Systems Pvt Ltd..

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by rohitamitpathak View Post
    1-can anybody tell me about those areas where i need to focus for fast searching... which concept i should use for this
    indexing

    Quote Originally Posted by rohitamitpathak View Post
    2- for respect of fast sarching which area are responsible like- how u create table, how u query and all that..
    how you create indexes

    Quote Originally Posted by rohitamitpathak View Post
    3- fast searching is depend on what?
    availability of appropriate indexes
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •