10.01.2012 11:15, ma_golyo wrote:
Currently the non index read count is over 30K, and this is just a simle
(few database object) test case.
Index reads means less record read - less I/O - faster execution.
Sure, but if these non-indexed reads occupy e.g. less than 10% of the
overall
10.01.2012 13:36, ma_golyo wrote:
The question is, the non index read is a firebird engine bug or not?
Maybe not really a bug but something sub-optimal.
(I think standard DDL command shoud ALWAYS read via indicies in the
background.)
Try creating an index on
Vander Clock Stephane wrote:
let speak first about the utf8
UTF8 it's just a way to encode special character like è à etc ..
for this utf8 will use combination of char upper than ascii #127
In this way, and it's not the less, UTF8 stay compatible with all
software that work with 8 bit string.
Tryed with ACS and DESC index. No change, still the same non index reads.
Do I upload my test database?
--- In firebird-support@yahoogroups.com, Dmitry Yemanov dimitr@... wrote:
10.01.2012 13:36, ma_golyo wrote:
The question is, the non index read is a firebird engine bug or not?
Tryed with the latest FB2.5 snapshot. It works! (It has 2 new index in
rdb$procedure_parameters)
Now I has only 92 index read. :)
(Execute time = 7s 422ms)
Thank you!
--- In firebird-support@yahoogroups.com, ma_golyo ma_golyo@... wrote:
Tryed with ACS and DESC index. No change, still the
Vander Clock Stephane wrote:
juste one question, i thing both are the same but with is the best to
store UTF8 code point ?
ASCII or ISO8859_1 ?
If you really do not care about collations, then OCTETS.
Stuff like UPPER, ORDER BY, etc. would not work properly anyway, so why
bother.
--
Milan
Marco Aurelio Castro wrote:
I'm not stupid! I program in the last 24 years and I know exactly what
I'm talking about. The Dot,Net provider FirebirdSql.Data.FirebirdClient.dll
is generating incompatible code to be processed by Firebird server.
Marco
There is a list specifically for the .net
What differences there is between WIN1252 and ISO8859_1?
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Milan Babuskov
To: firebird-support@yahoogroups.com
Sent: Tuesday, January 10, 2012 5:07 AM
Subject: Re: [firebird-support] UTF8 in firebird ?
On Tue, 10 Jan 2012 08:18:00 -0500, Ismael L. Donis Garcia
ism...@citricos.co.cu wrote:
What differences there is between WIN1252 and ISO8859_1?
The encoding is a superset of ISO 8859-1, but differs from the IANA's
ISO-8859-1 by using displayable characters rather than control characters
in the
Hello,
when i setup write async to true, it's mean the the database will store
in memory the write
and after several update (5 by default?) all the write will be flush to
the disk.
The main drawback, is that all the write are flush to the disk using the
current connection thread :(
it's mean
Hello,
How, via SQL text can i store bytes (that include for exemple #0, #1,
etc..) in OCTETS char column ?
Var char(16) i m happy i have for exemple
CHAR_TO_UUID() langrefupd25-intfunc-char_to_uuid.html and
UUID_TO_CHAR() langrefupd25-intfunc-uuid_to_char.html
for for other length ?
Thanks
On 10-1-2012 14:17, Vander Clock Stephane wrote:
Hello,
How, via SQL text can i store bytes (that include for exemple #0, #1,
etc..) in OCTETS char column ?
Var char(16) i m happy i have for exemple
CHAR_TO_UUID()langrefupd25-intfunc-char_to_uuid.html and
Dear colleagues,
We try to connect a Firebird (2.1.2.18118) database on Windows Server 2003
(32 bit) from Windows 7 x64.
Which ODBC (version, x32 or x64) should we use?
Kind regards,
Tee
~
Tiesheng Wu
Computer Manager
Wolfson Institute of
We try to connect a Firebird (2.1.2.18118) database on Windows Server 2003
(32 bit) from Windows 7 x64.
Which ODBC (version, x32 or x64) should we use?
This depends on your client application and not on your server. If your
client application is 32-bit then the 32-bit ODBC driver,
Stepane,
when i setup write async to true, it's mean the the database will store
in memory the write and after several update (5 by default?) all the write
will be flush to
the disk.
Firebird's internal consistency depends on careful write - Firebird
writes database pages in a specific
Hello, Vander!
Tuesday, January 10, 2012, 2:42:33 PM, you wrote:
VCS when i setup write async to true, it's mean the the database will store
VCS in memory the write
VCS and after several update (5 by default?) all the write will be flush to
VCS the disk.
before writing about 5 updates here,
ok thanks ann, i understand now why the write are done inside a
connection thread ...
On 1/11/2012 1:08 AM, Ann Harrison wrote:
Stepane,
when i setup write async to true, it's mean the the database will store
in memory the write and after several update (5 by default?) all the
write
VCS it's mean that if i m the unlucky guy to commit the 5th update
then my
VCS commit will be more slower because
VCS it's will also commit all the previous update.
why do you have so strange assumptions? You've made practical tests?
Or, if this is just a theory, what it is based on?
thanks the x' fit perfectly my need
On 1/10/2012 11:03 PM, Mark Rotteveel wrote:
On 10-1-2012 14:17, Vander Clock Stephane wrote:
Hello,
How, via SQL text can i store bytes (that include for exemple #0, #1,
etc..) in OCTETS char column ?
Var char(16) i m happy i have for exemple
Because tables should create automatically every year.
I am planning now, I will create one template table and copy it every year
automatically
--- In firebird-support@yahoogroups.com, Milan Babuskov milanb@... wrote:
Ahmet Nuri D wrote:
Hi, I want to copy table in store procedure, whith
How can I Prepare a suite of scripts? Is there any example script?
--- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote:
At 07:58 PM 11/01/2012, Ahmet Nuri D wrote:
Because tables should create automatically every year.
I am planning now, I will create one template table
I am useing Lazarus and Lazarus own Ib connection components .
Can't help you with Lazarus. I don't know what IB connection components
Lazarus has included. Perhaps there are components exposing the Services
API in particular for managing Firebird users. I recall that in IBX
there was
22 matches
Mail list logo