Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Posts
    6

    Unanswered: fast query execution

    Hi
    Is there anything for making the search fast in mysql? like indexing in MSSql Server. I want to make the search function fast.
    The few options that i have at the moement are:

    stored procedures
    Mysql Cache
    Indexing

    need to some good ideas

    thanks in advance

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    hi dizyn

    this is, what, the third database forum you've posted that question in? did you not like the other answers you were given?

    yes, like indexing in MS SQL Server, there is indexing in MySQL

    very, very much alike

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    May 2006
    Posts
    6
    Quote Originally Posted by r937
    hi dizyn

    this is, what, the third database forum you've posted that question in? did you not like the other answers you were given?

    yes, like indexing in MS SQL Server, there is indexing in MySQL

    very, very much alike

    well the thing i want to know more and more on it and wanted to have view of different peoples so that i can get some good.

  4. #4
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    Obviously he's not satisfied with your answer Rudy.

    Here's my answer :

    yes, like indexing in MS SQL Server, there is indexing in MySQL

    very, very much alike
    What else do you need to know?

  5. #5
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    dizyn,

    Suppose I answer a question in one forum, then move on to another, and find that there's an identical post there, where someone else has already answered it in a similar answer. This means that I would have entirely wasted my time (or the other person answering would have wasted THEIR time)

    The posting "shotgun" approach is just not very considerate of other's time...
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

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