Have the comments loaded from another database

  • Hello,

    With a database whose size is nearing 6 MB uncompressed (1.4 MB in tar.gz, wp_posts being itself 2.8 MB big and wp_comments being 2.1 MB big), comments are very very veeeeerrrrryyyyyyy slow to add on my blog, and I’m afraid that can be annoying for my visitors.

    I would like to ask you if you know if some users or coders have found a simple way (a plugin, or an accessible way to hack the files) to set the comments to be saved to and loaded from another database ? A database made only for the comments.

    That would make both the “contents” database faster, and the comments database faster too, I hope.

    I found no reference to that when searching, but I don’t see what could have been the proper search terms, so maybe I missed something important…

    Thanks a lot if you can help ??

    Regards,
    Sabinou

Viewing 1 replies (of 1 total)

  • I don’t feel like a 6 meg database is very large… could there be another problem at work here?

    I realise you can fit a lot of comments into a couple of meg, but still, there must be LOTS of sites out there running happily at that size.

    Is this a hosting issue maybe?

    …

    the problem with your request is that it’s illogical. Comments must relate to posts and to users, etc… so with two databases, you’d have to make a couple of connections to either database to pull IDs back and forth in order to display anything.

    that effectively doubles (if not triples) the effort.

    not to mention the impossibility, because I’m sure that wordpress simply won’t provide the tools to check IDs over multiple databases.

Viewing 1 replies (of 1 total)
  • The topic ‘Have the comments loaded from another database’ is closed to new replies.