SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Guru defiance's Avatar
    Join Date
    Oct 2004
    Location
    United states
    Posts
    663
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    do i have index on this column?

    hi

    my phpmyadmin structure for the table shows me this.

    ===========================
    Indexes:
    Keyname Type Cardinality Action Field
    id UNIQUE 29720 id

    ===========================


    this would seem like a joke, but do i have index on that table already?

    if i do, indexing the ID doesnot give me much increase of performance am i right?

    i need to index my field name;

    thanks...

    i am a total newbie in this....
    cheers

  2. #2
    SitePoint Guru defiance's Avatar
    Join Date
    Oct 2004
    Location
    United states
    Posts
    663
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    alright.

    so

    i create index on my field name, like this

    ============================
    Indexes:
    Keyname Type Cardinality Action Field
    id UNIQUE 29720 id
    name INDEX 29720 name

    ============================


    is that the right kind of index which i need to increase the speed?

    and
    when creating an index, phpmyadmin asked me for some size, but i didnt specify any size.

    what is this size means?

    and

    i did a query before and after i made the index name.
    before index the time was 0.0322 sec
    and after it was
    0.0301 sec

    hehehe
    the query returns 29 rows from 29 k rows.
    is it good enough?
    or is there anything else that i can do to make it faster/

    thanks

  3. #3
    SitePoint Guru defiance's Avatar
    Join Date
    Oct 2004
    Location
    United states
    Posts
    663
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ermm

    quick question, can we remove index from phpmyadmin?
    i cant seems to find the way to do it...

    thanks



Bookmarks

Posting Permissions

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