Subject Re: [firebird-support] Number of Firebird Users
Author Alain Bastien
Post date 2016-08-29T05:41:41Z
I have INSERT about 100000 records in a Table, the size of the FB Database grew up to 15MB

I DELETE the records the size remains 15MB.

After BACKUP and RESTORE thru FlameRobin then the size was reduce to 788Kb

Is this normal ? or can it me done automatically within the settings and configs




Kind Regards

Alain Bastien
34 Dr Ross Avenue
Rose Hill 72102
Mauritius
Mobile Tel: +230  5 719 30 30
Skype:alainbastien
Viber: 7320143





On Mon, Aug 29, 2016 at 9:08 AM, Alain Bastien <alainbastien@...> wrote:
ABout 100 simultaneous remote users may log in and insert data in a table via a stored procedure.

Pentium III 667/133 Mhz 1.GB Ram

WIll it be OK ?


Kind Regards

Alain Bastien
34 Dr Ross Avenue
Rose Hill 72102
Mauritius
Mobile Tel: +230  5 719 30 30
Skype:alainbastien
Viber: 7320143





On Sun, Aug 28, 2016 at 4:55 AM, Alain Bastien <alainbastien@...> wrote:
It has Windows 2003 R2 Server
6 x 18 GB SCSI Raid 4-5


Kind Regards

Alain Bastien
34 Dr Ross Avenue
Rose Hill 72102
Mauritius
Mobile Tel: +230  5 719 30 30
Skype:alainbastien
Viber: 7320143





On Sat, Aug 27, 2016 at 9:12 PM, 'Leyne, Sean' Sean@... [firebird-support] <firebird-support@yahoogroups. com> wrote:
 



> How many concurrent users may be created and connect to a FireBird
> database on such a Server ?
>
> Compaq Proliant ML 370 G1
>
> Pentium III 667/133 Mhz 1.2GB RAM 256MB Cache

Without a sense of the load/activity which would be placed on the server it is impossible to know.

Also, details about OS and the storage system (IDE HDD, Raid x??) to be used are required.

IMO: You are really talking about a system with a very low performance profile. After all the system would be 15-16 years old!!!


Sean