avatars stored in database - good solution? DB: Too many connections...
 

Hi Forum!

Since version 3 of vb attachments are not stored in the database any longer. But why are the avatar-pics still stored in the database?

I've large problems with my mysql-database. Often I get the message "too many connections" and the forum is down. I think it would be better and would save mysql-queries, if the attachments would be stored as files, or what do you think?

Has anybody else problems with the too many connections? I've a server of my own and it is running very fast. But if about 80 users are online on my vb, I get too many connections. Is that normal?

Greetings,
Chriss

are you on your own server or a shared host?

Own server: Intel 1 GHZ, 256 MB RAM. Not shared. Only my vb is running on the server, nothing else.

Greetings,
Chriss

good god thats slow. its time to look at getting a new server, but for the mean time have you filled out a request for a server optimization?

Ok, my (rented) server is not the newest one. But it should be good enought for one forum, or?

No, I havent optimized my server yet. I hope, that the standard-configuration of my provider is optimized. Maybe, you have some hints for me?

Back to the avatars: If they're stored in the database, they have to be loaded into the Server-memory. And that must influence the performance negatively. If the avatar is stored as file, the file needn't be opened by the server, but only by the client. Or do I make an error in reasoning?

Greetings,
Chriss

As i said, at vB.com go to the server configuration forum and request an optimization


Depdning, if you only are going to have 50~ people online constantly it might be good, like i said go and request a server config.

256 MB of RAM is not even sufficient for most desktop computers nowadays, let alone a server. I would have a minimum of 1 GB of RAM even for a small forum to provide a buffer room for bursts of traffic--a common cause of a "Too many connections" error.