Results 1 to 10 of 10

Thread: Possible one mutliple DB ?

Hybrid View

  1. #1

    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
    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. #3
    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.

  4. #4
    Join Date
    Jul 2009
    Location
    Hamburg, Germany
    Posts
    527
    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

  5. #5
    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

  6. #6
    Join Date
    Jul 2009
    Location
    Hamburg, Germany
    Posts
    527
    Can you tell us what kind of website do you have?
    Follow me on Twitter: @hendricius

  7. #7
    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

  8. #8
    Join Date
    Jul 2009
    Location
    Hamburg, Germany
    Posts
    527
    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

  9. #9
    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

  10. #10
    I'd find a better hosting plan which would support this load of data processing

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
  •