![]() |
![]() |
![]() |
||||
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
![]() ![]() |
|
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
Thread Tools |
![]() |
#1 |
Unregistered Abuser
Industry Role:
Join Date: Feb 2006
Posts: 25,683
|
Safe number of wordpress blogs on same database with different prefix?
What do you blog experts suggest?
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#2 |
Too lazy to wipe my ass
Industry Role:
Join Date: Aug 2002
Location: A Public Bathroom
Posts: 38,571
|
Elleventy, numpty nine
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#3 |
Too lazy to wipe my ass
Industry Role:
Join Date: Aug 2002
Location: A Public Bathroom
Posts: 38,571
|
but then im not an expert...
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#4 |
Confirmed User
Join Date: Feb 2007
Location: Sweden
Posts: 5,646
|
I would like to know this so here's a *BuMp!*
__________________
Free 🅑🅘🅣🅒🅞🅘🅝🅢 Every Hour (Yes, really. Free ₿itCoins.) (Signup with ONLY your Email and Password. You can also refer people and get even more.) |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#5 |
Confirmed User
Join Date: Feb 2007
Location: Sweden
Posts: 5,646
|
Of course it may vary much, but lets say each blog get about ~500 unique visitors/day.
__________________
Free 🅑🅘🅣🅒🅞🅘🅝🅢 Every Hour (Yes, really. Free ₿itCoins.) (Signup with ONLY your Email and Password. You can also refer people and get even more.) |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#6 |
Unregistered Abuser
Industry Role:
Join Date: Feb 2006
Posts: 25,683
|
Nobody ever answered, but I personally keep 3 on each right now and have no problems at all...
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#7 |
Confirmed User
Join Date: Nov 2005
Posts: 2,804
|
wouldnt rec more than one if you have traffic
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#8 |
Too lazy to set a custom title
Industry Role:
Join Date: Sep 2003
Posts: 22,651
|
i run 10-15 per db tops. make sure you're running wp-cache though
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#9 |
in a van by the river
Industry Role:
Join Date: May 2003
Posts: 76,806
|
Why not 100 blogs or more on 1 database?
Just use Blog Organizer and dump wordpress. Do you really want to have to update a shit load of WP blogs everytime a new security patch comes out? With BO you have one central admin and can run as many blogs as you can manage on one sever and then run more other other servers or at hosted blog sites. WP is a waste of time IMO.. |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#10 | |
♥♥♥ Likes Hugs ♥♥♥
Industry Role:
Join Date: Nov 2001
Location: /home
Posts: 15,841
|
Quote:
__________________
I like pie. |
|
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#11 |
♥♥♥ Likes Hugs ♥♥♥
Industry Role:
Join Date: Nov 2001
Location: /home
Posts: 15,841
|
Technically there really isn't a maximum number of tables you can have per database. There is, but it's so ridiculously large that most people will never reach it. Performance-wise, you won't see any difference whether you have 1 blog per db or 100. I would recommend splitting them up just for the sake of organization.
__________________
I like pie. |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#12 |
Confirmed User
Join Date: Nov 2006
Location: http://UUGallery.com http://UUGallery.com http://UUGallery.com http://UUGallery.com http://UUGallery.com http://UUGallery.com
Posts: 361
|
Simple answer actually. Every mysql table is a file which has two more additional files (index file, data, etc). Usual wordpress installation has around 10 tables which is 30 files (depends on wordpress version).
Every time when surfer clicks something, your system has to find a table which is in a file and it takes some time. If there are a lot of files, it takes a longer time to enumerate all the files and find a table you need. So if you have thousands of files in a folder it can take several seconds to open your file. I had a client who had 300,000 files in a folder and opening just one file for writing took around 25 seconds. So optimal limit should be around 300-350 wordpress installations in one database which is 1000 files in a folder. So you can be sure that everything works ok and it is also pretty enough for everyone.
__________________
![]() UUGallery v3.37 builder plugin for Wordpress! Now it builds FLV VIDEO Galleries! It grabs galleries from FHG's, generates thumbnails, resizes originals, arranges within your template and posts a gallery within 1 click! Start making money right now! ICQ# 475-719-552, Email+MSN: msnaddress[-~at~-]uusoftware.com |
![]() |
![]() ![]() ![]() ![]() ![]() |
![]() |
#13 |
Confirmed User
Join Date: Aug 2003
Posts: 915
|
Nice thread, I have been wondering this too. Thanks!
|
![]() |
![]() ![]() ![]() ![]() ![]() |