1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Speeding up a mediumtext search its sloooowww

Discussion in 'Databases' started by xbat, Apr 29, 2015.

  1. #1
    I have a myisam table that has a mediumtext its so incredibly slow. I am on a dedicated server but not have access to edit the mysql back end settings.
    1. the count distinct takes about 60 seconds
    2. tmp copy table takes about another 60 seconds. I am using left join. I was wondering if anyone had any ideas or suggestions? Even if I set a index on the column of say 300 it speeds it up by a few seconds but it still so slow. Any pointers would be appreciated.

    thank you


    EDIT: this is a mysql database.. I just realized its sort of in the wrong category.
    SEMrush
     
    xbat, Apr 29, 2015 IP
    SEMrush
  2. xbat

    xbat Active Member

    Messages:
    318
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    55
    #2
    If it helps any I found if you do a match against then it shaves off some time.. but its long.. :(
     
    xbat, Apr 29, 2015 IP
  3. jestep

    jestep Prominent Member Premium Member

    Messages:
    3,661
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    How much RAM does the server allow to use?

    What's the size of the table / index that you are querying?

    Can you post the query you are using?
     
    jestep, May 7, 2015 IP
  4. xbat

    xbat Active Member

    Messages:
    318
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    55
    #4
    Actually I just removed a bunch of AND's that weren't being used there was a list of 10.
     
    xbat, Jun 14, 2015 IP