On Tue, 6 Mar 2012 09:33:19 +0700, Iwan Cahyadi Sugeng
iwan.c.sug...@gmail.com wrote:
What i wish for the security system is at least if we deliver our
program
to customer without having direct access to the implementation (customer
install it by them self), we can say to them that by default
On Tue, 06 Mar 2012 03:31:13 -, cniggeler cnigge...@yahoo.com
wrote:
Hi,
Thank you for your reply. One clarification to this:
Firebird has embedded versions for most Linux and Unix systems.
The manual states, Under Linux, you always need a properly installed
server, be it Classic or
Using Firebird (work in progress) Document version 2.0.2
http://www.firebirdsql.org/pdfmanual/Using-Firebird_(wip).pdf
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote:
On Tue, 06 Mar 2012 03:31:13 -, cniggeler cniggeler@...
wrote:
Hi,
Thank you for your reply.
Hi Guys,
I'm using C# with Firebird v2.51 and FirebirdClient v2.7. I'm creating a
backup with FirebirdSql.Data.Services.FbBackup and the resulting Fbk file
appears to be valid. However, when I then try to add the resulting fbk file
to a zip archive (using DotNetZip), I get an error The
cniggeler wrote:
The manual states, Under Linux, you always need a properly installed server,
be it Classic or Super
I don't know which manual you're referring to, but that's just plain
wrong. All you need is libfbembed.so and couple of other helper files.
c) root access is required, at
If a stored procedure has three variables
DECLARE VARIABLE A NUMERIC(18,3);
DECLARE VARIABLE B NUMERIC(18,3);
DECLARE VARIABLE C DOUBLE PRECISION;
And a function is evaluated with these values
A = B / C;
A = 7.3 / 0.839080459770115
Then the value stored in A will be 8.7 not 8.700119 (a
Looking at creating a new database in a Win32 server that is expected to grow
quite large and trying to decide whether to use GUIDs or BIGINT for the primary
key. Will likely be using SuperServer architecture.
Besides hosting local data at each server, some or all of the data in the new
no one have any explanation ?
what i don't understand is that in select IDObj From DESCRIPTION where
ID='ID_NOT_EXIST' the speed is slow when no record are founded (so the number
of field/size in table Description must not matter, only the size of the index)
! but it's not the case, i do
Marsupilami79 schrieb am 06.03.2012 um 09:40 (+0100):
The statement about the usage of introducers is on Page 172 in the
middle of the page in a section with the heading String Literal:
An introducer will be required if the database column being searched
has a character set which is
why bigint ? you want to store more than 2.3 milliards row ?
integer = 4bytes
bigint = 8bytes
GUID = 16 bytes
and read just my previous article to understand that size of reccord are very
important in speed (can be x10 to x100 more faster some case, but do some test)
--- In
I can't find the article, but I would NOT use GUID.
GUID is a string, and afaik strings are not very efficient in combination with
FB. So I would use a numeric PK.
Benno
- Original Message -
From: nathanelrick
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 06,
Benno schrieb am 06.03.2012 um 20:24 (+0100):
I can't find the article, but I would NOT use GUID.
GUID is a string, and afaik strings are not very efficient in
combination with FB. So I would use a numeric PK.
Well, it's a 128 bit (or 16 byte) integer, usually formatted as a
string, like
Hi everybody.
Can someone tell me if there is a limit about the amount of 'when' conditions
in a case expressions, like in the 'in' statement?
Sorry by the bad english. Is not my native language.
Best regards.
Looking at creating a new database in a Win32 server that is expected to grow
quite large and trying to decide whether to use GUIDs or BIGINT for the
primary key. Will likely be using SuperServer architecture.
Besides hosting local data at each server, some or all of the data in the new
why bigint ? you want to store more than 2.3 milliards row ?
integer = 4bytes
bigint = 8bytes
GUID = 16 bytes
A BIGINT looks large, but once you work with dedicated PK value ranges
per site/server, I wouldn't go with an INTEGER.
Just a thought.
--
With regards,
Thomas Steinmaurer (^TS^)
Can someone tell me if there is a limit about the amount of 'when'
conditions in a case expressions, like in the 'in' statement?
I haven't tried. ;-)
One limit you have for sure is ~64K for the CREATE DDL statement and
AFAIK ~48K for the compiled BLR.
Ah, forgot the above. I misread your
Den 2012-03-06 21:52 skrev Thomas Steinmaurer såhär:
When using a BIGINT feed
by a generator, you can set a starting value per site/server and that
way, you somehow know the source of insertion when merging the
satellite databases with a central database.
Sounds risky and error prone...
Steve,
I'm using C# with Firebird v2.51 and FirebirdClient v2.7. I'm creating a
backup with FirebirdSql.Data.Services.FbBackup and the resulting Fbk file
appears to be valid. However, when I then try to add the resulting fbk file
to a zip archive (using DotNetZip), I get an error The
Den 2012-03-06 21:52 skrev Thomas Steinmaurer såhär:
When using a BIGINT feed
by a generator, you can set a starting value per site/server and that
way, you somehow know the source of insertion when merging the
satellite databases with a central database.
Sounds risky and error prone...
Den 2012-03-06 22:08 skrev Thomas Steinmaurer såhär:
Den 2012-03-06 21:52 skrev Thomas Steinmaurer såhär:
When using a BIGINT feed
by a generator, you can set a starting value per site/server and that
way, you somehow know the source of insertion when merging the
satellite databases
On Tue, Mar 6, 2012 at 1:47 AM, Kjell Rilbe kjell.ri...@datadia.se wrote:
If Sinática Monitor reports a transaction as Read Committed no Record
Versions, Read Write, am I right in these assumptions:
1. Read/write mode, i.e. both selects, updates, inserts and deletes are
allowed.
Yes.
21 matches
Mail list logo