Welcome to the E-Blah Community!
We would like to welcome you to our community and invite you to register an account or login.
Being a registered member is important, as it gives you several advantages over the normal Guest status. After registering you will be able to download files and images, post messages, and access member-only portions of the forum - just to name a few. Registration is quick and simple, and only takes about a minute of your time.

E-Blah Community    Technical Support    Question and Answer  ›  Another SQL vs. flatfile question
Users Browsing Forum
Googlebot, Yahoo! Bot and 1 Guests

Another SQL vs. flatfile question  This thread currently has 133 views. Print
1 Pages 1 Recommend Thread
tron
June 29, 2008, 5:59pm Report to Moderator Report to Moderator

E-Blah Member
Posts: 6
Posts Per Day: 0.09
Reputation: 100.00%
Reputation Score: +1 / -0
Time Online: 11 hours 10 minutes
I like the flatfile structure esp. on my shared hosting platform.  I like how its all under my own account directory--no shared/separate sql server to worry about.  So how many messages would be too many for the flat-file format on a Unix server?   It looks like it stores a txt file for each thread in the Messages directory?  I know I probably won't get that busy, but at what point should SQL be considered?  15,000+ messages...50,000+?   Would 50,000+ small files in a Unix directory start to tax the machine in terms of file access times and/or load?   Anyway, I guess I could just use flat-file until my provider says something about it   
  Anyone know of the biggest (in terms of messages) eblah flat-file forum?  Thanks for any info!
Logged Offline
Private Message Private message
iCONICA
June 30, 2008, 5:28am Report to Moderator Report to Moderator

E-Blah Member
Posts: 507
Gender: Male
Posts Per Day: 2.16
Reputation: 95.45%
Reputation Score: +21 / -1
Time Online: 9 days 7 hours 23 minutes
Location: Manchester UK
for the biggest, see this. Those are the biggest we know of.. http://www.eblah.com/forum/m-1075526918/


For the question. The bigger the forum doesn't necessarily tax the server any more than a smaller forum because there are more/larger files. It's more dependant on the number of times and the frequency those are accessed.

So generally a large forum will be accessed more because it will be more popular. So i suppose the question is, how busy, rather than how large. And that's totally dependant on your hosts servers...

I've had complaints with TOS violation server overload in the subject line when i was getting around 10 connection requests per second going to my hosts server, when i was hosting spybot search and destroy updates. That was too much for my shared host.

I'm happy with the flat file version at the moment, but my forum isn't that large... When the SQL version is fully up, running and with a few versions under its belt i'll sure be upgrading. The forums speed especially busy forums should be increased massively. Hopefully...  



Download All The Latest, Best Free Software!

i-CONICA's Reputation: Increase
Logged Offline
Site Site Private Message Private message Windows Live Messenger WLM Reply: 1 - 2
Justin
June 30, 2008, 5:32pm Report to Moderator Report to Moderator

The E-Blah Developer
E-Blah Programmer
Posts: 15,017
Gender: Male
Posts Per Day: 6.74
Reputation: 93.40%
Reputation Score: +297 / -21
Time Online: 36 days 18 hours
Location: Tallassee, AL
Age: 21
It depends.  It usually won't tax the server.  Older versions would tax the server a lot more than newer versions, as the database has been fixed up a little to make things quite quicker for small and large forums.


I do installs for $25 and upgrades for $20.
Technical support is always free.

  Donate to E-Blah!  

My Websites: Revolution Reality (My Blog)  |  MinistryTalk.com  |  Portfolio

"But you, O Lord, are a compassionate and gracious God, slow to anger, abounding in love and faithfulness." — Psalm 86:15 NIV

Logged Offline
Site Site Private Message Private message Reply: 2 - 2
1 Pages 1 Recommend Thread
Print

E-Blah Community    Technical Support    Question and Answer  ›  Another SQL vs. flatfile question