Re: [firebird-support] backup very slow and how often sweep a database ?

2011-12-21 Thread Vander Clock Stephane 
it's a disaster  i disable the gfix -sweep every night and launch it 
only when the difference between oldest transaction and next transaction 
is > 20 000 but this become true only after 5 hours :( so at the end 
everyday the difference between oldest transaction and next transaction 
grow by more than 20 000 :(

i can not run gfix everyday, it's took hours to finish :(

what i can do ?

stéphane

On 12/20/2011 8:41 PM, Ann Harrison wrote:
>
> Stéphane,
>
> > the probleme is that the sweep can take up to 5 hours to finish and the
> > backup up to 12 hours to finish :(
> > i know that in the backup i don't put the -g params (inhibit garbage
> > collection) but someone say me that
> > the -g do something else that the gfix.exe -sweep doesn't do ...
>
> As others have said, sweep does something that gbak doesn't. Specifically,
> sweep resets the "oldest interesting transaction" - the first 
> transaction in the
> system that may have rolled back leaving changes in the database. Keeping
> that number accurate was very important a decade ago when memory was
> expensive and rare and Firebird did not automatically undo changes when
> a transaction rolled back leaving the server alive.
>
> When reading records, Firebird must check the state of transactions newer
> than the oldest interesting. At startup, Firebird produces a bit
> vector of those
> transactions where each pair of bits indicates the transactions state:
> rolled back,
> committed, limbo, or active. The shorter the vector, the better, but 
> 64K bits
> isn't as interesting as it was a decade ago.
> >
> > now i need to know, how often i need to launch the gfix.exe -sweep and
> > the gbak.exe -B without the -g params ? everydays seam not anymore
> > possible because of the time taken
> > by these process...
> >
> > one time a month ?
> >
> Backup as often as lets you sleep at night. Sweep once a week if possible,
> once a month if not.
>
> Good luck,
>
> Ann
>
> 


[Non-text portions of this message have been removed]

Re: [firebird-support] backup very slow and how often sweep a database ?

2011-12-21 Thread Thomas Steinmaurer 
> it's a disaster  i disable the gfix -sweep every night and launch it
> only when the difference between oldest transaction and next transaction
> is>  20 000 but this become true only after 5 hours :( so at the end
> everyday the difference between oldest transaction and next transaction
> grow by more than 20 000 :(
>
> i can not run gfix everyday, it's took hours to finish :(
>
> what i can do ?

Find the reason why you produce such a transaction gap within 5 hours. 
Is it just the OIT which is behind or OAT as well? What's the output of 
gstat -h?

If OAT as well, then you have a long-running transaction or using commit 
retaining over and over again.

If you are using Firebird 2.1, then use the MON% tables to investigate 
running transactions. If you are using Firebird 2.5, then use the MON% 
tables and/or the Trace API to investigate the problem.

Regards,
^TS^


> stéphane
>
> On 12/20/2011 8:41 PM, Ann Harrison wrote:
>>
>> Stéphane,
>>
>>> the probleme is that the sweep can take up to 5 hours to finish and the
>>> backup up to 12 hours to finish :(
>>> i know that in the backup i don't put the -g params (inhibit garbage
>>> collection) but someone say me that
>>> the -g do something else that the gfix.exe -sweep doesn't do ...
>>
>> As others have said, sweep does something that gbak doesn't. Specifically,
>> sweep resets the "oldest interesting transaction" - the first
>> transaction in the
>> system that may have rolled back leaving changes in the database. Keeping
>> that number accurate was very important a decade ago when memory was
>> expensive and rare and Firebird did not automatically undo changes when
>> a transaction rolled back leaving the server alive.
>>
>> When reading records, Firebird must check the state of transactions newer
>> than the oldest interesting. At startup, Firebird produces a bit
>> vector of those
>> transactions where each pair of bits indicates the transactions state:
>> rolled back,
>> committed, limbo, or active. The shorter the vector, the better, but
>> 64K bits
>> isn't as interesting as it was a decade ago.
>>>
>>> now i need to know, how often i need to launch the gfix.exe -sweep and
>>> the gbak.exe -B without the -g params ? everydays seam not anymore
>>> possible because of the time taken
>>> by these process...
>>>
>>> one time a month ?
>>>
>> Backup as often as lets you sleep at night. Sweep once a week if possible,
>> once a month if not.
>>
>> Good luck,
>>
>> Ann
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu.  Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++
> Yahoo! Groups Links
>
>
>

Re[2]: [firebird-support] Re: backup very slow and how often sweep a database ?

2011-12-21 Thread Dmitry Kuzmenko 
Hello, Vander!

Tuesday, December 20, 2011, 6:22:54 PM, you wrote:

VCS> thanks dmitry !

>> What is the size of database?

VCS> 120 GB

one of our client have ~118gb database,
and performance is much better than yours. Since that database have
~300 concurrent users, they paid attention to the storage, and bought
new raid (md3220 from dell with 8 or 12 hard drives).
Now they have
sweep - from 5 to 40 minutes, depending on garbage amount
restore - ~7 hours
backup - ~2 hours

VCS> ok thanks now i will do like this. Run Sweep only if OIT < next 
VCS> transaction + 2

formula is incomple :-)
look at
http://www.ib-aid.com/articles/item66

there are explanation of relation between Oldest, Oldest snapshot,
oldest active and next transaction.

>> yes, up to 2-4 times faster. we made tests 3 years ago and found that.
VCS> hmm i not understand why ?

when gbak runs itself, it also makes backup by itself, telling
server to read the data. So, here is "intercommunication" between
2 processes - gbak and server.

when backup/restore is made via services api (or by gbak -se option),
it is being done by server itself, so, only 1 process involved.
Thus, no "intercommunication", and speed is faster.

VCS> everyday the difference between oldest transaction and next transaction
VCS> grow by more than 20 000 :(

Then you need to check transaction management in your applications.
First task is to eliminate long running transactions whenever
possible, or use read read committed transactions for reading
(they do not affect garbage collection).

-- 
Dmitry Kuzmenko, www.ib-aid.com

RES: [firebird-support] Re: Optimizing Firebird for SSD

2011-12-21 Thread Fabiano 
I mean: How to create a ram disc?

 

De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de karolbieniaszewski
Enviada em: quarta-feira, 21 de dezembro de 2011 04:34
Para: firebird-support@yahoogroups.com
Assunto: RES: [firebird-support] Re: Optimizing Firebird for SSD

 

  

Do you know what is RAM DISC?
If not then "google" for it ;-)

I can simple say that RAM DISC is some virtual disc created in RAM MEMORY.
After creation you use it as normal hard drive (copy database on it and use
as normal) with all benefits of RAM speed :)

but you must remember that if power failure or some hardware error occur and
your server stop - all data from RAM will be cleared.
Because of that you must do backup in some short interval.

e.g. your database is 3GB you can create RAM DISC 4GB and do backup to
normal HARD DISC or better you can create RAM DISC 8GB and do backup to also
RAM DISC and when backup process completed simple copy backup file to HARD
DISC what is tone faster.

RAM is now cheap - but i do not know what is your database size and what
scenario can be accomplished. 

--- In firebird-support@yahoogroups.com
 , "Fabiano" 
wrote:
>
> How put the entire database on RAM Disk?
> 
> 





[Non-text portions of this message have been removed]

SV: [firebird-support] Firebird classic vs supperclassic

2011-12-21 Thread Poul Dige 
The specific setup is for  ~150 hosted databases running 24x7 (probably we will 
change our server hardware before we reach 365 weeks). The databases are quite 
small ranging from 5-100MB, each DB has between 1-40 connections, but a typical 
picture will be around 50-100 connections for the whole server. We have no 
worries, though, about more connections, except that the 2.5.0 can't handle 
more than 500 connections at a time (this issue was corrected in 2.5.1).

I hope it helps!

Kind regards
Poul

PS. We have another server (Win 2008R2 64), running FB2.5 64 bit SC against one 
single 5GB DB with around 100 simultanious connections and many thousands 
connects/disconnects during the day as it serves a web site. Works like a 
charm, too.


Fra: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
På vegne af Jesus Garcia
Sendt: 20. december 2011 19:44
Til: firebird-support@yahoogroups.com
Emne: Re: [firebird-support] Firebird classic vs supperclassic



>
> We are running the x64 version of FB2.5.0 SC on ubuntu 11.04 server for
> almost a year and we are indeed happy. So far we didn't experience anything
> else but e.g. much faster connection time, compared to 2.1 CS.
>
How many concurrent users? What database size? 24x7x365?

Best wishes, Jesús

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]

[firebird-support] Firebird 1.5 - Stored procedure error 335544348

2011-12-21 Thread Nando 
Hi,

I'm having trouble with this simple stored procedure:

SET TERM !! ;
CREATE PROCEDURE test_proc (d_date TIMESTAMP)
  RETURNS (Result CHAR(50))
AS BEGIN
  Result = CAST(d_date AS CHAR(50));
  SUSPEND;
END !!
SET TERM ; !!

If I execute this statement it works fine:

"SELECT a.my_id, a.some_date, a.a_name, c.my_result FROM some_table a, 
test_proc(CAST('01/01/2011' AS TIMESTAMP)) c WHERE a.my_id < 10;"

But if I execute this other one it raises an exception.

"SELECT a.my_id, a.some_date, a.a_name, c.my_result FROM some_table a, 
test_proc(a.some_date) c WHERE a.my_id < 10;"

> ISC ERROR CODE:335544348
> no current record for fetch operation.

What am I doing wrong?

Thank your in advance for any help.

Hernando.

Re: SV: [firebird-support] Firebird classic vs supperclassic

2011-12-21 Thread Thomas Steinmaurer 
> The specific setup is for  ~150 hosted databases running 24x7 (probably we 
> will change our server hardware before we reach 365 weeks). The databases are 
> quite small ranging from 5-100MB, each DB has between 1-40 connections, but a 
> typical picture will be around 50-100 connections for the whole server. We 
> have no worries, though, about more connections, except that the 2.5.0 can't 
> handle more than 500 connections at a time (this issue was corrected in 
> 2.5.1).

Btw, you can setup several "instances" of Firebird server processes on 
one server to e.g. run particular databases in a "sandbox instance" 
where it doesn't matter if the something goes wrong and your Firebird 
server process dies.

So, you don't necessarily have to serve all databases through one 
Firebird instance. This also allows you to separate the user database, 
run instances with different firebird.conf settings etc...

Just a thought.


-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/


> I hope it helps!
>
> Kind regards
> Poul
>
> PS. We have another server (Win 2008R2 64), running FB2.5 64 bit SC against 
> one single 5GB DB with around 100 simultanious connections and many thousands 
> connects/disconnects during the day as it serves a web site. Works like a 
> charm, too.
>
>
> Fra: firebird-support@yahoogroups.com 
> [mailto:firebird-support@yahoogroups.com] På vegne af Jesus Garcia
> Sendt: 20. december 2011 19:44
> Til: firebird-support@yahoogroups.com
> Emne: Re: [firebird-support] Firebird classic vs supperclassic
>
>
>
>>
>> We are running the x64 version of FB2.5.0 SC on ubuntu 11.04 server for
>> almost a year and we are indeed happy. So far we didn't experience anything
>> else but e.g. much faster connection time, compared to 2.1 CS.
>>
> How many concurrent users? What database size? 24x7x365?
>
> Best wishes, Jesús
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu.  Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++
> Yahoo! Groups Links
>
>
>

Re: SV: [firebird-support] Firebird classic vs supperclassic

2011-12-21 Thread Alexey Kovyazin 
Hello Paul,
>
> The specific setup is for ~150 hosted databases running 24x7 (probably 
> we will change our server hardware before we reach 365 weeks). The 
> databases are quite small ranging from 5-100MB, each DB has between 
> 1-40 connections, but a typical picture will be around 50-100 
> connections for the whole server. We have no worries, though, about 
> more connections, except that the 2.5.0 can't handle more than 500 
> connections at a time (this issue was corrected in 2.5.1).
>

Interesting.
What is the hardware configuration for above system you mentioned above?

Regards,
Alexey Kovyazin
IBSurgeon


[Non-text portions of this message have been removed]

[firebird-support] Re: backup very slow and how often sweep a database ?

2011-12-21 Thread Aage Johansen 
Dmitry wrote:
<<
Hello, Aage!
Tuesday, December 20, 2011, 3:02:26 PM, you wrote:
AJ> Everyday i sweep the database and i backup it
AJ> gfix.exe -sweep
AJ> and just after a backup like this :
AJ> gbak.exe -B -t -v -z
...
 >>

The lines starting with "AJ>" was my quote from Stéphane's email.
It's not _my_ problem :-)


That said, it seems that the only solution for 
Stéphane is that he fixes his handling of 
transactions (see also post from Thomas 
SteinMaurer).  His transactions (possibly 
excepting those that are ReadOnly/ReadCommitted) 
must do a COMMIT at appropriate places (and more often than "never").


-- 
Aage J.

[firebird-support] Firebird as .msi?

2011-12-21 Thread Ingeborg Hjelt Kramprud 
I’ve just gotten a customer who demands that if they should install
Firebird Client it has to be .msi. To be honest I’m not sure how to do this
and I don’t have any experience with it. I’ve read some documentation
saying that you can do a silent install of Firebird, but I can’t figure out
how you actually do it. I’m a bit in the dark here, but I really need to
figure out how to satisfy this customer.



Can you guys please help me?

Med vennlig hilsen

Ingeborg Hjelt Kramprud

Cell:+47 480 06 579
Skype:ingeborg.hjelt.kramprud
LinkedIn: http://www.linkedin.com/in/kramprud


[Non-text portions of this message have been removed]





++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[firebird-support] user profiles

2011-12-21 Thread reserve161 
I am new to Firebird, and would be interested in understanding
how to set up a "common user" such that this user doesn't have
administrative rights.

What are the suggested "rights" for such users?  I am still in the 
early stages of implementation (a testbed, prior to a production
server).

I come from the SQL Server 2000 world, but am brand new to unix
and also to Firebird.

Thanks in advance!
Bryan

Re: [firebird-support] backup very slow and how often sweep a database ?

2011-12-21 Thread Vander Clock Stephane 


On 12/21/2011 12:08 PM, Thomas Steinmaurer wrote:
>
> > it's a disaster  i disable the gfix -sweep every night and launch it
> > only when the difference between oldest transaction and next transaction
> > is> 20 000 but this become true only after 5 hours :( so at the end
> > everyday the difference between oldest transaction and next transaction
> > grow by more than 20 000 :(
> >
> > i can not run gfix everyday, it's took hours to finish :(
> >
> > what i can do ?
>
> Find the reason why you produce such a transaction gap within 5 hours.
> Is it just the OIT which is behind or OAT as well? What's the output of
> gstat -h?
>

ok, i think i found ... few hours ago the difference
between OIT and next transaction was 50 000 but
now i try again gstat -h and the difference if only 5 ...

Database header page information:
 Flags   0
 Checksum12345
 Generation  1003772708
 Page size   8192
 ODS version 11.2
 Oldest transaction  1003732753
 Oldest active   1003732754
 Oldest snapshot 1003732754
 Next transaction1003732757
 Bumped transaction  1
 Sequence number 0
 Next attachment ID  39942
 Implementation ID   26
 Shadow count0
 Page buffers0
 Next header page0
 Database dialect3
 Creation date   Oct 30, 2011 2:23:04
 Attributes  force write, no reserve

 Variable header data:
 Sweep interval: 0
 *END*

i don't do any long transaction on the server but this is hard
to know if one select or update was not long to return as lot of 
application are
connected to the database, but all application use the same procedure
to select or update the data :

procedure doSQL
begin
   StartTransaction
   Try
 select or update data
 committransaction
   except
 rollbacktransaction
   end;
end;

for now the only explanation i see is that we do very lot of transaction 
(average 225 / Secondes is it lot ?)
on the server and this why 2 sean to be too little ... with around 
19 millions transactions by days
i thing i must use much more than 2 (1 million?)

How much transaction by second can firebird can handle ?


thanks for all
> 


[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird classic vs supperclassic

2011-12-21 Thread Vander Clock Stephane 
not sure, pro will confirm, but i thing classic do more io on the disk 
(locking, etc) than superclassique

On 12/17/2011 8:29 PM, jegazarco wrote:
>
> Hello, we have to select between the two models for a new client. Is a 
> critical system that will run 24x7x365 with an average of 100-200 
> concurrent users and 5 Gb database growth a year, starting with 10 Gb 
> database.
>
> The deployment will Windows 2008 R2 64, 32 Gb RAM and the most 
> important is the reliability of the system.
>
> Superclassic is out a year, but a lot of people prefer classic over 
> SC. I would like to know experiences of people using them, and the 
> reliability of both from your POV.
>
> Regards,
> Jesus
>
> 


[Non-text portions of this message have been removed]

Re: [firebird-support] Re: backup very slow and how often sweep a database ?

2011-12-21 Thread Vander Clock Stephane 

>
> one of our client have ~118gb database,
> and performance is much better than yours. Since that database have
> ~300 concurrent users, they paid attention to the storage, and bought
> new raid (md3220 from dell with 8 or 12 hard drives).
> Now they have
> sweep - from 5 to 40 minutes, depending on garbage amount
> restore - ~7 hours
> backup - ~2 hours
>

in fact on the server the backup is around 2 hours (restore 24hours but 
this
because of index i m not surprise). but backup from different server 
than the
FB server take twice more time :(

hard drive: 5 RAID 0 SAS 15k on DELL server

yes i take some risk but i have no other choice need speed !


> >> yes, up to 2-4 times faster. we made tests 3 years ago and found that.
> VCS> hmm i not understand why ?
>
> when gbak runs itself, it also makes backup by itself, telling
> server to read the data. So, here is "intercommunication" between
> 2 processes - gbak and server.
>

that explain why it's so slow on the remote computer :)

> VCS> everyday the difference between oldest transaction and next 
> transaction
> VCS> grow by more than 20 000 :(
>
> Then you need to check transaction management in your applications.
> First task is to eliminate long running transactions whenever
> possible, or use read read committed transactions for reading
>

to select or update the data we do only like this :

procedure doSQL
begin
   StartTransaction
   Try
 select or update data
 committransaction
   except
 rollbacktransaction
   end;
end;

for now the only explanation i see is that we do very lot of transaction 
(average 225 / Secondes is it lot ?)
on the server and this why 2 sean to be too little ... with around 
19 millions transactions by days
i thing i must use much more than 2 (1 million?)



[Non-text portions of this message have been removed]

Re: [firebird-support] backup very slow and how often sweep a database ?

2011-12-21 Thread Thomas Steinmaurer 
>>> it's a disaster  i disable the gfix -sweep every night and launch it
>>> only when the difference between oldest transaction and next transaction
>>> is>  20 000 but this become true only after 5 hours :( so at the end
>>> everyday the difference between oldest transaction and next transaction
>>> grow by more than 20 000 :(
>>>
>>> i can not run gfix everyday, it's took hours to finish :(
>>>
>>> what i can do ?
>>
>> Find the reason why you produce such a transaction gap within 5 hours.
>> Is it just the OIT which is behind or OAT as well? What's the output of
>> gstat -h?
>>
>
> ok, i think i found ... few hours ago the difference
> between OIT and next transaction was 50 000 but
> now i try again gstat -h and the difference if only 5 ...
>
> Database header page information:
>   Flags   0
>   Checksum12345
>   Generation  1003772708
>   Page size   8192
>   ODS version 11.2
>   Oldest transaction  1003732753
>   Oldest active   1003732754
>   Oldest snapshot 1003732754
>   Next transaction1003732757
>   Bumped transaction  1
>   Sequence number 0
>   Next attachment ID  39942
>   Implementation ID   26
>   Shadow count0
>   Page buffers0
>   Next header page0
>   Database dialect3
>   Creation date   Oct 30, 2011 2:23:04
>   Attributes  force write, no reserve
>
>   Variable header data:
>   Sweep interval: 0
>   *END*
>
> i don't do any long transaction on the server but this is hard
> to know if one select or update was not long to return as lot of
> application are
> connected to the database, but all application use the same procedure
> to select or update the data :
>
> procedure doSQL
> begin
> StartTransaction
> Try
>   select or update data
>   committransaction
> except
>   rollbacktransaction
> end;
> end;
>
> for now the only explanation i see is that we do very lot of transaction
> (average 225 / Secondes is it lot ?)

That's quite a number, when running in 24x7 mode! Although due to the 
example above, it seems you do explicit transaction management. So, 
either you still use automcommit somewhere, which results in a new 
transaction for every piece of work, our you have a lot of connections 
and work to be done by explicit transactions.

I really think that you are using autocommit as well. The least 
expensive transactions are READ COMMIT READ ONLY, so basically make use 
of at least read-only transactions, when you are selecting stuff from 
the database and don't write.

I misunderstanding of how to work with transactions efficiently is 
probably the number one reason for server performance degradation and 
performance problems in general.

> on the server and this why 2 sean to be too little ... with around
> 19 millions transactions by days
> i thing i must use much more than 2 (1 million?)
>
> How much transaction by second can firebird can handle ?

It seems to "work" in your case, but at least there is a limit of 2^31 
transactions before you urgently have to run a backup/restore cycle, 
which ain't be fun with a 120GB database and more or less 24x7 requirements.

So, get used to transactions. Use them wise and efficiently. Separate 
read-ony and read/write transactions. Reaching the 1 billion limit in 
~52 days is quite a number!


-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/

Re: [firebird-support] Re: backup very slow and how often sweep a database ?

2011-12-21 Thread Thomas Steinmaurer 
>> one of our client have ~118gb database,
>> and performance is much better than yours. Since that database have
>> ~300 concurrent users, they paid attention to the storage, and bought
>> new raid (md3220 from dell with 8 or 12 hard drives).
>> Now they have
>> sweep - from 5 to 40 minutes, depending on garbage amount
>> restore - ~7 hours
>> backup - ~2 hours
>>
>
> in fact on the server the backup is around 2 hours (restore 24hours but
> this
> because of index i m not surprise). but backup from different server
> than the
> FB server take twice more time :(
>
> hard drive: 5 RAID 0 SAS 15k on DELL server
>
> yes i take some risk but i have no other choice need speed !
>
>
 yes, up to 2-4 times faster. we made tests 3 years ago and found that.
>> VCS>  hmm i not understand why ?
>>
>> when gbak runs itself, it also makes backup by itself, telling
>> server to read the data. So, here is "intercommunication" between
>> 2 processes - gbak and server.
>>
>
> that explain why it's so slow on the remote computer :)
>
>> VCS>  everyday the difference between oldest transaction and next
>> transaction
>> VCS>  grow by more than 20 000 :(
>>
>> Then you need to check transaction management in your applications.
>> First task is to eliminate long running transactions whenever
>> possible, or use read read committed transactions for reading
>>
>
> to select or update the data we do only like this :
>
> procedure doSQL
> begin
> StartTransaction
> Try
>   select or update data
>   committransaction
> except
>   rollbacktransaction
> end;
> end;

I'm curious what access components you use? Perhaps ZEOS?


> for now the only explanation i see is that we do very lot of transaction
> (average 225 / Secondes is it lot ?)
> on the server and this why 2 sean to be too little ... with around
> 19 millions transactions by days
> i thing i must use much more than 2 (1 million?)

I still think you won't resolve the problem with a larger sweep 
interval. ;-)


-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/

Re: [firebird-support] Re: backup very slow and how often sweep a database ?

2011-12-21 Thread Vander Clock Stephane 

> > to select or update the data we do only like this :
> >
> > procedure doSQL
> > begin
> > StartTransaction
> > Try
> > select or update data
> > committransaction
> > except
> > rollbacktransaction
> > end;
> > end;
>
> I'm curious what access components you use? Perhaps ZEOS?
>

no, direct api call :) ... but i get inspired from the UIB code

> > for now the only explanation i see is that we do very lot of transaction
> > (average 225 / Secondes is it lot ?)
> > on the server and this why 2 sean to be too little ... with around
> > 19 millions transactions by days
> > i thing i must use much more than 2 (1 million?)
>
> I still think you won't resolve the problem with a larger sweep
> interval. ;-)
>

ok, i just make a confusion, it's not the difference between the next
transaction and the OIT that must be done but between the
OST (oldest snapshot) and the OIT that must be done ! (and many
book write this mistake, thanks that i read an article from vlad about
it)

in my case it's always close to 1 so no sweep really need !



[Non-text portions of this message have been removed]

Re: [firebird-support] backup very slow and how often sweep a database ?

2011-12-21 Thread Vander Clock Stephane 

>
> That's quite a number, when running in 24x7 mode! Although due to the
> example above, it seems you do explicit transaction management. So,
> either you still use automcommit somewhere, which results in a new
> transaction for every piece of work, our you have a lot of connections
> and work to be done by explicit transactions.
>
> I really think that you are using autocommit as well. The least
> expensive transactions are READ COMMIT READ ONLY, so basically make use
> of at least read-only transactions, when you are selecting stuff from
> the database and don't write.
>

not really autocommit, but i don't let any transaction open.
when the code need some data, he call a global procedure that will gave
him the data he need. the procedure will open (and close) an transaction
each time and query the fb server.

now i can open a transaction when each thead start and close it when each
thead end but i always hear that transaction must be short as possible :(

stéphane


[Non-text portions of this message have been removed]

Re: [firebird-support] backup very slow and how often sweep a database ?

2011-12-21 Thread Thomas Steinmaurer 
>> That's quite a number, when running in 24x7 mode! Although due to the
>> example above, it seems you do explicit transaction management. So,
>> either you still use automcommit somewhere, which results in a new
>> transaction for every piece of work, our you have a lot of connections
>> and work to be done by explicit transactions.
>>
>> I really think that you are using autocommit as well. The least
>> expensive transactions are READ COMMIT READ ONLY, so basically make use
>> of at least read-only transactions, when you are selecting stuff from
>> the database and don't write.
>>
>
> not really autocommit, but i don't let any transaction open.
> when the code need some data, he call a global procedure that will gave
> him the data he need. the procedure will open (and close) an transaction
> each time and query the fb server.
>
> now i can open a transaction when each thead start and close it when each
> thead end but i always hear that transaction must be short as possible :(

Long running read committed read-only transactions aren't a problem at 
all. If you are using Firebird 2.5, I wonder what the Trace API returns 
in respect to transaction tracing.


-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/

Re: [firebird-support] Re: Optimizing Firebird for SSD

2011-12-21 Thread W O 
Use the RAM disc and to do backup also in the RAM disc, great idea!!!

Everyday I learn something new here.

Thank you for the tip.

Greetings.

Walter.



On Wed, Dec 21, 2011 at 2:34 AM, karolbieniaszewski <
liviusliv...@poczta.onet.pl> wrote:

> **
>
>
> Do you know what is RAM DISC?
> If not then "google" for it ;-)
>
> I can simple say that RAM DISC is some virtual disc created in RAM MEMORY.
> After creation you use it as normal hard drive (copy database on it and
> use as normal) with all benefits of RAM speed :)
>
> but you must remember that if power failure or some hardware error occur
> and your server stop - all data from RAM will be cleared.
> Because of that you must do backup in some short interval.
>
> e.g. your database is 3GB you can create RAM DISC 4GB and do backup to
> normal HARD DISC or better you can create RAM DISC 8GB and do backup to
> also RAM DISC and when backup process completed simple copy backup file to
> HARD DISC what is tone faster.
>
> RAM is now cheap - but i do not know what is your database size and what
> scenario can be accomplished.
>
> --- In firebird-support@yahoogroups.com, "Fabiano" 
> wrote:
> >
> > How put the entire database on RAM Disk?
> >
> >
>
>  
>


[Non-text portions of this message have been removed]





++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[firebird-support] Dealing with Currency in FB 1.5.6

2011-12-21 Thread chris meelhuysen 
I have an application that I took over programming.

Its written in Delphi 7, uses SQLDirect (BDE replacement), and Firebird
1.5.6

There are float fields all over the database storing currency values.  I
believe this to be causing all kinds of rounding errors.

I have been researching , but I'd like some confirmation.

I think i read that numeric(18,4) was the best way to store them with BCD
enabled in BDE settings is that accurate or what else would be better?

I am pretty sure i need to change all those floats to something, enable BCD
and then the programming in delphi side can just remain the same?

I get mixed information and can't tell what versions of what they are using.

Any help would be appreciated.

Thank you!!


[Non-text portions of this message have been removed]

RES: [firebird-support] Re: Optimizing Firebird for SSD

2011-12-21 Thread trskopo 

> I mean: How to create a ram disc?

There is a software to create ram disk, a free one and commercial.
Free version can store up to 4GB.

But RAM disk, if I don't mistake, can only do in WIN OS.

Backup from/to RAM disk is very2 fast.

Regards,
Sugiarto

[firebird-support] How to build Firebird TCP/IP ConnectionString

2011-12-21 Thread Michael Powell 
Are there any examples which include how to build a Firebird TCP/IP
ConnectionString?

Thank you...

Regards,

Michael


[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird as .msi?

2011-12-21 Thread Venus Software Operations 
Not a msi fan and have not made one in a long time, but as an idea how 
about wrapping the FB installer in a msi and doing a silent installation 
from it, they get their msi

Kind regards
Bhavbhuti


On 21/12/2011 04:37 pm, Ingeborg Hjelt Kramprud wrote:
> I’ve just gotten a customer who demands that if they should install
> Firebird Client it has to be .msi. To be honest I’m not sure how to do this
> and I don’t have any experience with it. I’ve read some documentation
> saying that you can do a silent install of Firebird, but I can’t figure out
> how you actually do it. I’m a bit in the dark here, but I really need to
> figure out how to satisfy this customer.
>
>
>
> Can you guys please help me?
>
> Med vennlig hilsen
>
> Ingeborg Hjelt Kramprud
>
> Cell:+47 480 06 579
> Skype:ingeborg.hjelt.kramprud
> LinkedIn: http://www.linkedin.com/in/kramprud
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu.  Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++
> Yahoo! Groups Links
>
>
>
>

-- 


Thanking you.

Yours Faithfully,
For Venus Software Operations

Bhavbhuti Nathwani
___
Softwares for Indian Businesses at: http://www.venussoftop.com

venussof...@gmail.com
venussof...@mail.ru
___

Please note: We reserve complete rights for policy changes in the future and 
the same will be applicable immediately as and when made.  Attachments may get 
corrupted before reaching you, in such a situation please let us know and we 
will resend you the same at the earliest.  We do not take any responsibility 
for data loss of any type and kind.  Data safety remains the sole the 
responsibility of the users of our softwares.
___

Internet email confidentiality:

This message may contain information that may be privileged or confidential.  
If you are not the addressee nor are you responsible for the delivery of the 
message to the addressee indicated in this email, then you may not copy or 
deliver this email to anyone and you should notify the sender by reply email 
and then destroy this message.

Please reply email immediately to this message with REMOVE in the subject, if 
you or your employer do not consent to email of this kind.

Opinions, conclusions and other information in this message that do not relate 
to the official business of my firm shall be understood as neither given nor 
endorsed by my company.





++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Re: [firebird-support] How to build Firebird TCP/IP ConnectionString

2011-12-21 Thread Thomas Steinmaurer 
Michael,

> Are there any examples which include how to build a Firebird TCP/IP
> ConnectionString?

it's pretty much:

[/]:

* Examples:

With physical server path: localhost:c:\data\mydb.fdb
or with alias: localhost:mydb.fdb

In case of an alias (the preferred way btw), you then need something 
like that in aliases.conf in the Firebird root directory:

mydb.fdb=c:\data\mydb.fdb

Or if the Firebird server is listening on a different port than the 
default 3050:

localhost/4050:c:\data\mydb.fdb

Or if it is a remote server:

myserver:c:\data\mydb.fdb

etc ...

I think you get the idea.

-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/



> Thank you...
>
> Regards,
>
> Michael
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu.  Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++
> Yahoo! Groups Links
>
>
>

RES: [firebird-support] Re: Optimizing Firebird for SSD

2011-12-21 Thread karolbieniaszewski 
Here is link to good Ram Disc software

http://www.romexsoftware.com/en-us/vsuite-ramdisk/download.html

there is free version up to 4GB Ram Disc
if you need bigger you must buy it - but price is not big 

Karol Bieniaszewski

--- In firebird-support@yahoogroups.com, "Fabiano"  wrote:
>
> I mean: How to create a ram disc?
> 
>

Re: [firebird-support] backup very slow and how often sweep a database ?

2011-12-21 Thread Vander Clock Stephane 

> Long running read committed read-only transactions aren't a problem at
> all. If you are using Firebird 2.5, I wonder what the Trace API returns
> in respect to transaction tracing.
>

Ok, so i will start to think about transaction pool (only for read only
red commited transaction)

Can you confirm

if a read only transaction (isc_tpb_read + isc_tpb_read_committed + 
isc_tpb_rec_version)
die without any commit or rollback (network
error, application bug, etc.) then it's no matter for the firebird server ?

Also what a time aleave i need to setup for each transaction before to
commit them? 30 s ? 1 min ? 10 min ? more ?

Thanks by advance


[Non-text portions of this message have been removed]

[firebird-support] What the best big table or several small table

2011-12-21 Thread Vander Clock Stephane 
Hello,

i have one table with lot of index (around 30, record around 20 millions)

We access the data only throught query like

select First 200 skip 0  from MyTable where c = XY and d = zw and A 
 > x and b < Z ... ORDERBY C, D

what is the best :

1/ One table with lot of record ?
2/ Several tables with fewer records ?

because i can split easyly the number of row in 10 differents tables

also is an empty on not very used table use firebird ressource ?

thanks for your help

RE: [Spam] Re: [firebird-support] How to build Firebird TCP/IP ConnectionString

2011-12-21 Thread wiyono 
Dear Sir.

 

Whether the folder where the database should be shared?
if yes? whether this share is full or read only.

 

 

Thanks

 

 

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: Thursday, December 22, 2011 13:09
To: firebird-support@yahoogroups.com
Subject: [Spam] Re: [firebird-support] How to build Firebird TCP/IP
ConnectionString

 

  

Michael,

> Are there any examples which include how to build a Firebird TCP/IP
> ConnectionString?

it's pretty much:

[/]:

* Examples:

With physical server path: localhost:c:\data\mydb.fdb
or with alias: localhost:mydb.fdb

In case of an alias (the preferred way btw), you then need something 
like that in aliases.conf in the Firebird root directory:

mydb.fdb=c:\data\mydb.fdb

Or if the Firebird server is listening on a different port than the 
default 3050:

localhost/4050:c:\data\mydb.fdb

Or if it is a remote server:

myserver:c:\data\mydb.fdb

etc ...

I think you get the idea.

-- 
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/

> Thank you...
>
> Regards,
>
> Michael
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++
> Yahoo! Groups Links
>
>
>



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1890 / Virus Database: 2109/4695 - Release Date: 12/21/11



[Non-text portions of this message have been removed]