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

[Chriss74]

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

[Zachery]

are you on your own server or a shared host?

[Chriss74]

Originally Posted by Zachery

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

[Zachery]

Originally Posted by Chriss74

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?

[Chriss74]

Originally Posted by Zachery

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

[Zachery]

Originally Posted by Chriss74

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.

[filburt1]

Originally Posted by Chriss74

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

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.