**
now i do in loop with one single thread, one connection :
Start transaction
insert Into Table_A(ID) VALUES('#randomchar'); //
insert Into Table_A(ID) VALUES('#randomchar'); // (100 000 loop)
insert Into Table_A(ID) VALUES('#randomchar'); //
commit transaction
average
Hi,
I' looking for information about OpenSource or commercial document management
systems using FireBird. The system must be able survive in a corporative
environment (many groups of users and very large number of documents).
Regards,
Nols Smit
[Non-text portions of this message have been
Greetings All,
Does anyone know how I can accomplish this from within a stored procedure?
I need to convert a timestamp 01/26/2012 05:38:32am to a string
01262012053832.
Will actually be using CURRENT_TIMESTAMP within the stored procedure.
Still using Firebird 1.5.3 (Hope to convert down the
I think I have something figured out...
- Original Message -
From: SoftTech
To: firebird-support@yahoogroups.com
Sent: Thursday, January 26, 2012 5:50 AM
Subject: {Disarmed} [firebird-support] How do I convert a timestamp to a
string from within a stored procedure?
trskopo wrote:
Or, I can record changes via my app, which one do you thing is better,
regarding database performance and size?
Database would work faster and have smaller size if logging is done in
application. Therefore, if those are the most important parameters, you
should do it in
SoftTech wrote:
Does anyone know how I can accomplish this from within a stored procedure?
I need to convert a timestamp 01/26/2012 05:38:32am to a string
01262012053832.
Will actually be using CURRENT_TIMESTAMP within the stored procedure.
You could use EXTRACT() to extract day, month,
Hi Svein,
Tks very much for your quick answer. Indeed, the statement did return one
row. Instead of adding it to POSICOES, i removed it from
EXCESSOS_VELOCIDADE. After this i was able to create the FK.
Again, thank you very much for your help.
2012/1/26 Svein Erling Tysvær
Extract(day,month ... From ?date)
And then some ifs and etc
Regards, Bogdan
Lp, Bogdan
Sent from Win 7.5 mobile
-Original Message-
From: SoftTech
Sent: 26.1.2012 12:50
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How do I convert a timestamp to a string from
within
Twice the size is an old and possibly still a good guess, I think. It
all depends on the number and size of the indices.
So to restore an 11GB database we should have 22GB available where
TempDirectories points?
Disclaimer: This message (including attachments) is confidential and may be
Rick,
So to restore an 11GB database we should have 22GB available where
TempDirectories points?
No.
Download our free tool DBInfo
(http://ib-aid.com/products/firebird_interbase/monitoring/dbinfo) and
open your database there.
Look at Index Pages size. If you have the single table with the
Or is this what you're already doing, just that your example was
simplified?
HTH,
Set
yes, of course parametized queries will be more fast, but i don't think they
will change the ratio in the test (it's will simply be more fast for both
variantes)
I would disagree!
Your test was
i'm evaluating firebird embedded for use in small workgroup setting.
i'm a little confused by documentation.
The embedded server in the Windows library, fbembed.dll, now uses
Superclassic, not Superserver as previously,
thus unifying its model with that of local connection to Superclassic on
26.01.2012 23:39, Jeff wrote:
I see that it supports multi-processes.
True, but only the ones running on the same single host.
how about multi-user / DB on shared network drive ?
A standalone server should be used instead in this scenario.
Dmitry
13 matches
Mail list logo