Re: [firebird-support] Number of Firebird Users

[Stefan Heymann li...@stefanheymann.de [firebird-support]]

> I have INSERT about 10 records in a Table, the size of the FB Database 
> grew up to 15MB

> I DELETE the records the size remains 15MB.

That is normal. A Firebird database is organized in pages that are
allocated when needed. When you delete the records, the pages will be
marked as free and will be reused when you add more data.

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

That is also normal because GBAK (the tool that FlameRobin calls to do
the job) will build the new database from scrath and then fill it with
the data from the backup (also done with GBAK) that you have done
before. So there are no empty pages after the Restore.

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

As I said before, you don't have to do it because Firebird will reuse
the unused pages before it will allocate new pages. So there is
nothing to worry about.

If you want to do it anyway on a regular basis you can write a batch
file that calls GBAK (which is a command-line tool) for a backup and
then again for a restore. However, you must be aware that the database
will not be usable during the restore and that everything that is
added/changed/deleted in the database *after the time the backup has
started* is lost.


Best Regards

Stefan

Re: [firebird-support] Number of Firebird Users

[Alain Bastien alainbast...@gmail.com [firebird-support]]

I have INSERT about 10 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 AvenueRose Hill 72102MauritiusMobile Tel: +230  5 719 30 30*
*Skype:alainbastien*
*Viber: 7320143*





On Mon, Aug 29, 2016 at 9:08 AM, Alain Bastien 
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 AvenueRose Hill 72102MauritiusMobile Tel: +230  5 719 30 30*
> *Skype:alainbastien*
> *Viber: 7320143*
>
>
>
>
>
> On Sun, Aug 28, 2016 at 4:55 AM, Alain Bastien 
> wrote:
>
>> It has Windows 2003 R2 Server
>> 6 x 18 GB SCSI Raid 4-5
>>
>>
>> *Kind Regards*
>>
>>
>> *Alain Bastien*
>>
>>
>>
>> *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230  5 719 30 30*
>> *Skype:alainbastien*
>> *Viber: 7320143*
>>
>>
>>
>>
>>
>> On Sat, Aug 27, 2016 at 9:12 PM, 'Leyne, Sean' s...@broadviewsoftware.com
>> [firebird-support]  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
>>>
>>> 
>>>
>>
>>
>

Re: [firebird-support] Number of Firebird Users

[Alain Bastien alainbast...@gmail.com [firebird-support]]

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 AvenueRose Hill 72102MauritiusMobile Tel: +230  5 719 30 30*
*Skype:alainbastien*
*Viber: 7320143*





On Sun, Aug 28, 2016 at 4:55 AM, Alain Bastien 
wrote:

> It has Windows 2003 R2 Server
> 6 x 18 GB SCSI Raid 4-5
>
>
> *Kind Regards*
>
>
> *Alain Bastien*
>
>
>
> *34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230  5 719 30 30*
> *Skype:alainbastien*
> *Viber: 7320143*
>
>
>
>
>
> On Sat, Aug 27, 2016 at 9:12 PM, 'Leyne, Sean' s...@broadviewsoftware.com
> [firebird-support]  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
>>
>> 
>>
>
>

Re: [firebird-support] Number of Firebird Users

[Alain Bastien alainbast...@gmail.com [firebird-support]]

It has Windows 2003 R2 Server
6 x 18 GB SCSI Raid 4-5


*Kind Regards*


*Alain Bastien*



*34 Dr Ross AvenueRose Hill 72102MauritiusMobile Tel: +230  5 719 30 30*
*Skype:alainbastien*
*Viber: 7320143*





On Sat, Aug 27, 2016 at 9:12 PM, 'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support]  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
>
> 
>

RE: [firebird-support] Number of Firebird Users

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

> 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