Results 1 to 10 of 10

Thread: Possible one mutliple DB ?

  1. #1
    SonnyCooL's Avatar
    SonnyCooL is offline HeeHa
    Join Date
    Jan 2010
    Location
    Melb/Malaysia
    Posts
    920
    Thanks
    250
    Thanked 92 Times in 78 Posts

    Possible one mutliple DB ?

    Is that possible multiple Data Base on a single wordpress site ???

    cause i have huge db and i think my dedi can't handle it

  2. #2
    TopDogger's Avatar
    TopDogger is online now Über Hund
    Join Date
    Jan 2009
    Location
    Hellfire, AZ
    Posts
    3,075
    Thanks
    347
    Thanked 913 Times in 697 Posts
    No. It is not possible to split the database unless you want to re-write the WordPress core applications. I would find it very hard to believe that a dedicated server cannot handle a WordPress site--regardless of its size.

    If you really did have a problem with resource capacity, you could split the database from the applications and run them on two separate dedicated servers. That would not require re-writing of any core files.

    If your database is slowing down, then optimize it daily or weekly.
    "Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote." -- Benjamin Franklin


  3. Thanked by:

    Aziz (26 June, 2010), SonnyCooL (26 June, 2010)

  4. #3
    Andy101's Avatar
    Andy101 is offline Code Otaku
    Join Date
    Aug 2009
    Location
    Kanazawa
    Posts
    1,261
    Thanks
    173
    Thanked 304 Times in 231 Posts
    Make sure you have a page cache:
    WordPress › WP Super Cache WordPress Plugins

    This avoids WP rebuilding pages from scratch on each page request.

    With a cache, the page is stored as a static file so database access is minimized and the page renders faster.

  5. Thanked by:

    m42 (9 October, 2010)

  6. #4
    hendricius's Avatar
    hendricius is offline The Interwebs are mine!
    Join Date
    Jul 2009
    Location
    Hamburg, Germany
    Posts
    527
    Blog Entries
    1
    Thanks
    21
    Thanked 50 Times in 37 Posts
    Wow, you must have pretty huge blog... I think splitting one database in two on the same host won't help even if it is be possible to do.

    As somebody above has suggested, use WP Super Cache to reduce the number of MySQL requests.
    Follow me on Twitter: @hendricius

  7. #5
    SonnyCooL's Avatar
    SonnyCooL is offline HeeHa
    Join Date
    Jan 2010
    Location
    Melb/Malaysia
    Posts
    920
    Thanks
    250
    Thanked 92 Times in 78 Posts
    yah is really huge db and the problem is i use a lot wild card for search
    so was thinking i can split out to few cat. custom fields to minus search process ....

    btw wp cache ain't work, cause i have live time update for search

  8. #6
    hendricius's Avatar
    hendricius is offline The Interwebs are mine!
    Join Date
    Jul 2009
    Location
    Hamburg, Germany
    Posts
    527
    Blog Entries
    1
    Thanks
    21
    Thanked 50 Times in 37 Posts
    Can you tell us what kind of website do you have?
    Follow me on Twitter: @hendricius

  9. #7
    SonnyCooL's Avatar
    SonnyCooL is offline HeeHa
    Join Date
    Jan 2010
    Location
    Melb/Malaysia
    Posts
    920
    Thanks
    250
    Thanked 92 Times in 78 Posts
    Quote Originally Posted by hendricius View Post
    Can you tell us what kind of website do you have?
    one of them is on my signature ..... condo (smaller db for now)
    currently with 150k posting and receiving around 15k UV and 100k pageview (daily, due to hosting restriction) else i can get 15x pageview on daily uv (base on pass record) ... changing to dedi soon but i think it only cool for a very short period

  10. #8
    hendricius's Avatar
    hendricius is offline The Interwebs are mine!
    Join Date
    Jul 2009
    Location
    Hamburg, Germany
    Posts
    527
    Blog Entries
    1
    Thanks
    21
    Thanked 50 Times in 37 Posts
    Do you import feed from real estate listing websites in wordpress DB and than using search? It is kind of strange platform for search engine...
    Follow me on Twitter: @hendricius

  11. #9
    Aziz's Avatar
    Aziz is offline no investment, no glory
    Join Date
    May 2009
    Location
    IL
    Posts
    736
    Thanks
    588
    Thanked 243 Times in 168 Posts
    I'd find a better hosting plan which would support this load of data processing

  12. #10
    SonnyCooL's Avatar
    SonnyCooL is offline HeeHa
    Join Date
    Jan 2010
    Location
    Melb/Malaysia
    Posts
    920
    Thanks
    250
    Thanked 92 Times in 78 Posts
    Quote Originally Posted by hendricius View Post
    Do you import feed from real estate listing websites in wordpress DB and than using search? It is kind of strange platform for search engine...

    not by feed
    cause wp is the only script i understand (still learning) and it work pretty well on SEO

Tags for this Thread

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
  •