slow loading database

Discussion in 'Databases' started by auctionbaylive, Jun 22, 2010.

0
  1. #1
    I have a very large database (sqlor some thing) of over 250,000 articles and it loads very slow! is there away to speed it up so my host do not time it out

    Here it is

    I have shared hosting

    Thanks
     
    auctionbaylive, Jun 22, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Are you using a caching mechanism like APC? If not, I would start using it immediately.

    There's many ways to optimize your app / database. Without knowing exactly what you are doing it's hard to recommend anything specific.

    How is your database organized, database and table structures? Are your queries optimized (Ex: Not using SELECT *) at all? Do you have proper indexes on the correct columns?
     
    jestep, Jun 22, 2010 IP
  3. auctionbaylive

    auctionbaylive Active Member

    Messages:
    416
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #3
    Hi:

    I'm not an expert on databases but if you know about it I would pay $20.00 to optimize. Pm if interested
     
    auctionbaylive, Jun 22, 2010 IP
  4. netload

    netload Member

    Messages:
    105
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    28
    #4
    Try to use option log-slow-queries= in your my.cnf to detect slow queries, after that try to optimize indexes and/or tuning my.cnf
     
    netload, Jun 23, 2010 IP