Hi Mark,
On 2021-09-13 15:59, Maya Opperman wrote:
Another possibility is to set coercion rules for new data type
for your connection, see
https://firebirdsql.org/file/documentation/release_notes/html/en/4_0/rlsnotes40.html#rnfb4-msql-set-bind-native-to-legacy-coercion-rules
Thanks Vlad!
Hello Vlad,
13.09.2021 11:43, Thomas Steinmaurer wrote:
Hello,
congratulations to the Firebird 4 release!
How do I best find out what has been changed in the area of MON$
tables and especially Firebird Trace API.
MON$ tables get a bit of mentioning in the Release Notes, e.g. what
fields
Hello,
congratulations to the Firebird 4 release!
How do I best find out what has been changed in the area of MON$ tables
and especially Firebird Trace API.
MON$ tables get a bit of mentioning in the Release Notes, e.g. what
fields have been added etc. resp. I could extract the DDL for all M
> 14.11.2016 21:00, Thomas Steinmaurer wrote:
>
>> But still, IMHO it does not explain why additional connect request with
>> SS while running OLTP emul with 100 users are taking considerable time,
>> although they are almost instant with SC?
>
>This is no
Hi Vlad,
> 14.11.2016 20:27, Thomas Steinmaurer wrote:
> ...
>> So, with 16G RAM and an OLTP emul database with ~ 2,9G, it is still
>> recommended with Firebird 3 SS and the shared page cache, to rather use
>> a smaller number, lets say 50K and keep the FileSystemCacheThr
Hello Vlad,
> 14.11.2016 16:09, Thomas Steinmaurer wrote:
>> Hello Simon,
>>
>>> Thomas Steinmaurer wrote Mon, 14 Nov 2016 15:03:41
>>> +0300:
>>>
>>>> Hello,
>>>>
>>>> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperSer
Hello Simon,
> Thomas Steinmaurer wrote Mon, 14 Nov 2016 15:03:41
> +0300:
>
>> Hello,
>>
>> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof.
>> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores)
>>
>> Per
Hi,
> Hi,
>
>> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof.
>> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores)
>>
>> Performance related changes in firebird.conf are:
>>
>> DB Page Size = 8K
>> DefaultDbCachePages = 128K (DB specific page buffer
Hi,
> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof.
> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores)
>
> Performance related changes in firebird.conf are:
>
> DB Page Size = 8K
> DefaultDbCachePages = 128K (DB specific page buffers = 0)
> TempCa
Hello,
using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof.
with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores)
Performance related changes in firebird.conf are:
DB Page Size = 8K
DefaultDbCachePages = 128K (DB specific page buffers = 0)
TempCacheLimit =
in-visual-studio-2015/
>
> On Mon, Nov 14, 2016 at 9:21 AM, Thomas Steinmaurer <mailto:t...@iblogmanager.com>> wrote:
>
> Hello,
>
> do you have any recommendations what toolset to use when it comes to
> profiling a Windows native process resp. Firebird 3
Hello,
do you have any recommendations what toolset to use when it comes to
profiling a Windows native process resp. Firebird 3.0.1 in particular?
Basically I intend to see where time is spent (or perhaps it is a sync
contention) when running a loadtest against Firebird 3.0.1 SS 64-bit on
Wind
> Whole story here :
>
> https://plus.google.com/105626236962310493174/posts/3UZB71NjUhA
>
> Copy of message
> - - - - - - - - - - - - - - - -
> Is there a tool (or way) to debug database step by step.
>
> Now we have weird situation where delete from one database fails, on
> foreign key error
Hello Adriano,
> Adriano,
>
>> On 21/07/2016 05:42, Thomas Steinmaurer wrote:
>>> Any further ideas?
>>>
>>>
>> What the DE_DE collation expands, and you don't need to add parameter,
>> are these chars:
>>
>> static const Ex
> 31.08.2016 05:14, Adriano dos Santos Fernandes wrote:
>>
>> In the code I'm writing, I had good opportunities to use some features
>> that the compiler flags we're using disallowed, like lambda and default
>> arguments for template parameter.
>>
>> Also we have the ubiquitous ugly iterator types
Adriano,
> On 21/07/2016 05:42, Thomas Steinmaurer wrote:
>> Any further ideas?
>>
>>
> What the DE_DE collation expands, and you don't need to add parameter,
> are these chars:
>
> static const ExpandChar ExpansionTbl[NUM_EXPAND_CHARS + 1] = {
>
On 20.07.2016 13:19, Thomas Steinmaurer wrote:
> Hello Adriano,
>
>> On 20/07/2016 04:35, Thomas Steinmaurer wrote:
>>> Hello,
>>>
>>> I need to sort umlauts in its expanded expression (ae, oe, ue), thus I
>>> thought
>>> to define my own
Hello Adriano,
> On 20/07/2016 04:35, Thomas Steinmaurer wrote:
>> Hello,
>>
>> I need to sort umlauts in its expanded expression (ae, oe, ue), thus I
>> thought
>> to define my own collation based on DE_DE, but this does not seem to work.
>> Perh
Hello,
I need to sort umlauts in its expanded expression (ae, oe, ue), thus I thought
to define my own collation based on DE_DE, but this does not seem to work.
Perhaps it is not supported anyway that way.
Test case:
create collation de_de_expansion for iso8859_1 from de_de
'DISABLE-EXPANSION
>> I could simply use the entire snapshot build and sync the moving parts like
>> security database, conf files, UDFs etc. or perhaps I could simply replace a
>> single (executable) file (firebird.exe?) taken from the snapshot ZIP file?
>>
>
> Not firebird.exe but engine12.dll.
Thanks!
Thomas
-
>> 21.04.2016 13:35, Thomas Steinmaurer wrote:
>> ...
>>>> As you already found that fbtracemgr is OK, i guess something is not
>>>> fully
>>>> correct (or stepped on some another issue) at FB Trace Manager. Could you
>>>> show
&g
> 21.04.2016 13:35, Thomas Steinmaurer wrote:
> ...
>>> As you already found that fbtracemgr is OK, i guess something is not
>>> fully
>>> correct (or stepped on some another issue) at FB Trace Manager. Could you
>>> show
>>> how do you wor
> 21.04.2016 13:35, Thomas Steinmaurer wrote:
> ...
>>> As you already found that fbtracemgr is OK, i guess something is not
>>> fully
>>> correct (or stepped on some another issue) at FB Trace Manager. Could you
>>> show
>>> how do you wor
> On 04/21/2016 12:47 PM, Thomas Steinmaurer wrote:
>> Hi Alex,
>>
>>>>> Hello Vlad,
>>>>>
>>>>>>> 20.04.2016 0:47, Thomas Steinmaurer wrote:
>>>>>>> ...
>>>>>>>> What else could I provi
Hello Vlad,
>>> Have you had time to look at it?
>
> Looking now, but seems you already on the way ;)
>
>>> Unfortunately this now also has happened in a production environment at
>>> a customer site.
>>>
>>> We did quite some testing in the trace area at Firebird 3 Alpha stage
>>> and I can't
Hi Alex,
>>> Hello Vlad,
>>>
>>>>> 20.04.2016 0:47, Thomas Steinmaurer wrote:
>>>>> ...
>>>>>> What else could I provide so that you can investigate the offending
>>>>>> thread?
>>>>> Ful
Hi again,
> Hello Vlad,
>
>>> 20.04.2016 0:47, Thomas Steinmaurer wrote:
>>> ...
>>>> What else could I provide so that you can investigate the offending
>>>> thread?
>>>
>>>Full memory dump, please.
>
> Have you ha
Hello Vlad,
>> 20.04.2016 0:47, Thomas Steinmaurer wrote:
>> ...
>>> What else could I provide so that you can investigate the offending
>>> thread?
>>
>>Full memory dump, please.
Have you had time to look at it?
Unfortunately this now also has
Vlad,
> 20.04.2016 0:47, Thomas Steinmaurer wrote:
> ...
>> What else could I provide so that you can investigate the offending
>> thread?
>
> Full memory dump, please.
I'm not that familiar with WinDbg and played around with it.
The stack trace of th
Hello Vlad,
> 20.04.2016 0:47, Thomas Steinmaurer wrote:
> ...
>> What else could I provide so that you can investigate the offending
>> thread?
>
> Full memory dump, please.
I have been using sysinternals procdump for that with:
procdump -ma
Is this what you
Hello,
first of all, congratulations to Firebird 3.
I'm basically seeking for assistance pin-pointing an issue here with
Firebird 3 SuperServer 32-bit on Windows 10 Prof., as it seems, in the
context of the Trace API. This all is not an issue with Firebird 2.5.
Unfortunately, it is only reprod
> 05.04.2016 18:24, Dimitry Sibiryakov wrote:
>>
>> In V4 will we still support connection to database on network share or
>> mapped drive
>> using the trick with overwriting "local" connection string to named pipes
>> one?
>> I.e. can expand_share_name() be cleaned out of isc_file.cpp?
>
> I'd g
Alexander,
>> Hello,
>>
>> I'm using Firebird 2.5.4 x86 on Windows 7.
>>
>> A simple table:
>>
>> CREATE TABLE T1
>> (
>> ID INTEGER NOT NULL,
>> CONSTRAINT PK_T1 PRIMARY KEY (ID)
>> );
>>
>>
>> The following trace configuration:
>>
>>
>> enabled true
>> log_connections true
>> log
Hello Dmitry,
> 20.10.2015 00:18, Thomas Steinmaurer wrote:
>>
>> with Firebird 3, what are the capabilities to disallow unwanted users to
>> open my database?
>>
>> I thought perhaps preparing a database pointing to itself as security
>> database might be a
Hello,
with Firebird 3, what are the capabilities to disallow unwanted users to
open my database?
I thought perhaps preparing a database pointing to itself as security
database might be an option (MON$DATABASE.MON$SEC_DATABASE=Self), but
this database then still can be opened by an embedded co
Hello,
I'm using Firebird 2.5.4 x86 on Windows 7.
A simple table:
CREATE TABLE T1
(
ID INTEGER NOT NULL,
CONSTRAINT PK_T1 PRIMARY KEY (ID)
);
The following trace configuration:
enabled true
log_connections true
log_transactions true
log_statement_finish true
print_plan true
Hello,
I'm using a Firebird 3 x86 Windows snapshot (SuperServer) from October
15, 2015 using Pavel's OLTP emulator to put load on Firebird, the trace
functionality and our FB TraceManager.
I'm using the following trace configuration:
database = oltpemul.fdb
{
enabled = true
log_statement
I can't exactly recall concrete numbers from the past, but I wonder if
Firebird can currently go beyond > 10MB/s disk I/O utilization. And this
is not about being limited by spinning disk and seek time (random I/O).
>>>
>>> You'll be wonder if reevaluate concrete numbers...
>>
Vlad,
>> I can't exactly recall concrete numbers from the past, but I wonder if
>> Firebird can currently go beyond > 10MB/s disk I/O utilization. And this
>> is not about being limited by spinning disk and seek time (random I/O).
>
> You'll be wonder if reevaluate concrete numbers...
Firebir
> On Saturday, March 21, 2015, Thomas Steinmaurer <mailto:t...@iblogmanager.com>> wrote:
>
> >
>
> IMHO 99% of the Firebird customer-base isn't in the "distributed system
> business", thus state-of-the art scale up (instead of scale out)
>> I think it would be vastly better for Firebird to address operating across
>> cheap
>> commodity servers than to optimize for exotic -- and hyper-expensive --
>> servers.
>
> Operating across servers is ... a cluster, which suggests MPI as the method
> to distribute messages between the nodes.
>> Are you using the durability term strictly in the area of transactions
>> or in a sense that a successful write survives a system crash?
>
> Durability has all sorts of interesting characteristics. In general, it
> means that after something bad, committed transactions persist. The
> questio
> On Thursday, February 19, 2015, Thomas Steinmaurer <mailto:t...@iblogmanager.com>> wrote:
>
> Jim,
>
> >
>
> http://www.cio.co.uk/insight/data-management/jim-starkeys-nosql-low-down-it-wont-solve-big-data-3598479/
>
> What do you think
Jim,
> http://www.cio.co.uk/insight/data-management/jim-starkeys-nosql-low-down-it-wont-solve-big-data-3598479/
What do you think about "tunable consistency" instead of "eventual
consistency"?
http://www.datastax.com/documentation/cassandra/2.0/cassandra/dml/dml_config_consistency_c.html
Than
Jim,
> Has anyone done any performance studies on zlib?
I never trust benchmarks which haven't run on my own, but slide 8 here:
http://www.slideshare.net/Hadoop_Summit/kamat-singh-june27425pmroom210cv2
is a good fit regarding cpu time vs. compression ratio.
Working with Cassandra for the last t
> Recently wire compression was implemented by Alex. It uses well known zlib
> library.
Have you guys considered LZ4? https://code.google.com/p/lz4/
It is getting very popular in the big-data / NoSQL area for both,
compressing data on disk and over-the-wire.
Regards,
Thomas
On Linux zlib
Hi,
> Is there a way to add/remove NOT NULL to a column using single DDL command in
> Firebird (2.5 for the start)? I'm tuning support for Entity Framework
> Migrations in .NET provider and this is one case.
This will be available in Firebird 3.
Regards,
Thomas
-
> When we decided not to validate constraints on declaration, our
> reasoning was that computations and database access were expensive and
> any decent application programmer or DBA would always validate
> constraints before declaring them and control access to the constrained
> items until the con
Hello,
does the following reflect the real status quo on what needs to be done
for Beta 2?
http://tracker.firebirdsql.org/browse/CORE/fixforversion/10586
Thanks,
Thomas
--
Firebird-Devel mailing list, web interface at
> Obviously it is possible to add support for multiple installs, although it
> does add complexity to the installer and we don't really have a way at the
> moment to deal with uninstallation because we don't have a mechanism in place
> to track what instances of firebird are running on which ports.
> Ann and I are settled at the hotel in Prague. Looking forward to seeing
> everyone.
Unfortunately I can't attend, but make sure to spoil the bar and session
recording works (if there is any). ;-)
Good luck and have fun.
Thomas
> P.S. This discussion is purely theoretical as compatibility has already
> been restored in the meantime.
I never said a properly written application could be affected, I said
something
has clearly changed as existing applications suddenly return the wrong
result.
Martijn,
P.S. This discussion is purely theoretical as compatibility has already
been restored in the meantime.
>>>
>>> I never said a properly written application could be affected, I said
>>> something
>>> has clearly changed as existing applications suddenly return the wrong
>>> resul
> 03.10.2014 21:20, Martijn Tonies (Upscene Productions) wrote:
>
>> I get exactly what's happening.
>>
>> And it's clear to me -something- has changed in this regard, cause if it
>> weren't, everything would be just fine.
>
> Then tell us how a properly written application (the one not ignoring
>
>>> RELATION_NAME
>>> =
>>> Statement failed, SQLSTATE = 22001
>>> arithmetic exception, numeric overflow, or string truncation
>>> -string right truncation
>>> -expected length 10, actual 21
>>> SQL>
>> Seems to be a problem with using the TYPE OF clause for the data type.
>> When I re
Hello,
> I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit.
>
> In a UTF8 database, I have a table with the following name:
>
> A_VERY_LONG_TABLENAME
>
>
> And a package with a single selectable SP, basically querying the table
> names:
>
> SET TERM ^^ ;
> CREATE OR ALTER P
Hello,
I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit.
In a UTF8 database, I have a table with the following name:
A_VERY_LONG_TABLENAME
And a package with a single selectable SP, basically querying the table
names:
SET TERM ^^ ;
CREATE OR ALTER PACKAGE PKG_SCHEMA_
Hello,
I'm using the build mentioned in the subject, 32-bit, on Windows 7 64-bit.
I have the following sequence of created domains in isql:
SQL> create domain d_mydomain bigint;
SQL> commit;
SQL> create domain d_mydomain_1 bigint;
SQL> commit;
SQL> create domain d_mydomain_2 bigint;
SQL> create
Claudio,
>> -Original Message-
>> From: Thomas Steinmaurer [mailto:t...@iblogmanager.com]
>> Sent: Domingo, 04 de Mayo de 2014 5:43
>>>
>>> Personally, I find it frustrating to what Firebird disk IO
>> profile when performing large select/sorts
Sean,
>>> 1. A query's operations (the reading of the data and sorting) execute
>>> in a single thread/process, correct?
>>
>> Correct.
>>
>>> 2. Is Internal sorting performed by the ExecuteWriteTempSortBlock()
>> step?
>>
>> Internal buffer is sorted as soon as filled up to its limit and
Hello Vlad,
>> When I execute a stored procedure (with or without package, doesn't
>> matter), e.g.:
>>
>> select * from pkg_schema.s_user_tables;
>>
>> I also see appropriate PREPARE_STATEMENT etc. events for the SELECT
>> statement. Whereas when I execute a stored function with e.g.:
>>
>> selec
> will there be or is there already support for stored function execution
> in the Trace API similar to stored procedures?
Sure, it is under development.
>>>
>>> Thanks for the information.
>>
>> Done, happy testing ;)
>
> Lovely. ;-) Thanks a lot!
>
> Will give it a
will there be or is there already support for stored function execution
in the Trace API similar to stored procedures?
>>>
>>> Sure, it is under development.
>>
>> Thanks for the information.
>
> Done, happy testing ;)
Lovely. ;-) Thanks a lot!
Will give it a go in the forthc
>> Tried todays snapshot build (Win 32-bit). The output looks like a bit
>> weird regarding package/procedure name:
>>
>> 2014-02-18T21:59:55.1080 (456:00C32D20) EXECUTE_PROCEDURE_FINISH
>> tourism.fdb (ATT_332, TOURISM:NONE, UNICODE_FSS, TCPv4:127.0.0.1)
>> C:\Program Files (x86)\Upsce
Hello Vlad,
>> 14.02.2014 22:50, Thomas Steinmaurer wrote:
>>
>>> Would like to do so, but the latest snapshot build for Windows available
>>> is from 2 days ago. Just letting you know.
>>
>> Windows builds are broken at the moment, please wait a bit.
&g
Vlad,
>> will there be or is there already support for stored function execution
>> in the Trace API similar to stored procedures?
>
> Sure, it is under development.
Thanks for the information.
Regards,
Thomas
--
M
Hello,
will there be or is there already support for stored function execution
in the Trace API similar to stored procedures?
I don't see that anywhere mentioned. At least the fbtrace.conf template
file doesn't offer e.g. log_function_start, log_function_finish trace
configuration parameters.
Good point. I think it makes sense. I'll look at it (a bit later). Would
you like to
see procedure name prefixed with package name (PACKAGE.PROCEDURE)
>>>
>>> This would be consistent with the rest of the codebase, so IMHO it
>>> should be done this way.
>> Sounds good.
>
> Che
>> Good point. I think it makes sense. I'll look at it (a bit later). Would you
>> like to
>> see procedure name prefixed with package name (PACKAGE.PROCEDURE)
>
> This would be consistent with the rest of the codebase, so IMHO it
> should be done this way.
Sounds good.
Thank you,
Thomas
Hello,
when I execute a stored procedure which is part of a package with e.g.:
select * from pkg_schema.s_user_tables;
I guess, it would make sense to also have the package name somewhere in
the trace output for the EXECUTE_PROCEDURE_* event. Does this make sense?
For the above call, currentl
> http://permalink.gmane.org/gmane.comp.db.firebird.python/360
At least with the ZIP distribution of Firebird 3 Alpha 2, you need to
create a Firebird user via gsec first.
Regards,
Thomas
--
Managing the Performance of
> sorry seems that was loading the old fbclient from
> /usr/lib/x86_64-linux-gnu/
> ldd /opt/flamerobin/bin/flamerobin | grep libfb
> libfbclient.so.2 => /usr/lib/x86_64-linux-gnu/libfbclient.so.2
> (0x7f1e8dfec000)
>
> cat /etc/ld.so.conf.d/x86_64-linux-gnu.conf
> /lib/x86_64-linux-gnu
> /usr
> You now should see the UNICODE initialization problem in the trace output.
No, i see ATTACH_DATABASE event by this application.
>>>
>>> That's a pity. ;-)
>>>
>>> Do you have the FIREBIRD environment variable set?
>>
>> No.
>>
PS does you tried LoadLibraryEx with L
You now should see the UNICODE initialization problem in the trace output.
>>>
>>> No, i see ATTACH_DATABASE event by this application.
>>
>> That's a pity. ;-)
>>
>> Do you have the FIREBIRD environment variable set?
>
> No.
>
>>> PS does you tried LoadLibraryEx with LOAD_WITH_ALTE
> 02.02.2014 11:23, Thomas Steinmaurer wrote:
>> From a configuration side, I only changed the port in firebird.conf to
>> 4050, so
>> I'm running SuperServer.
>
> No, to run Super-anything, you must run/install firebird.exe with -m
> switch.
Thanks, th
Hello Vlad,
> PS If you provide me with reproducible sample i'll try to investigate it
The only thing I could provide is a 32-bit Delphi application which
points to an Embedded library. The executable must not be in the same
directory. Would this be useful?
>>>
>>> At
Hello,
I'm sure I'm doing something wrong here ...
Testing Alpha 2 x86 on Windows using the ZIP distribution. From a
configuration side, I only changed the port in firebird.conf to 4050, so
I'm running SuperServer.
A first isql session with:
isql 'localhost/4050:tourism.fdb' -user tourism -pas
Hello,
is there any particular reason (except probable ZIP size) why the trace
plugin and fbtracemgr.exe is not included in the embedded distribution?
Thanks,
Thomas
--
WatchGuard Dimension instantly turns raw network d
Hello Vlad,
>>> PS If you provide me with reproducible sample i'll try to investigate it
>>
>> The only thing I could provide is a 32-bit Delphi application which
>> points to an Embedded library. The executable must not be in the same
>> directory. Would this be useful?
>
> At least, we can
>> Any further ideas?
>
> Not at me.
>
> Regards,
> Vlad
>
> PS If you provide me with reproducible sample i'll try to investigate it
The only thing I could provide is a 32-bit Delphi application which
points to an Embedded library. The executable must not be in the same
directory. Would th
> It is interesting now, that the trace works for an isql based client
> session, even when using UTF8 as character set, but fails with e.g.
> Database Workbench. The only difference is that isql is in the same
> directory as embedded, but DBW isn't, although pointing to the same
>>
It is interesting now, that the trace works for an isql based client
session, even when using UTF8 as character set, but fails with e.g.
Database Workbench. The only difference is that isql is in the same
directory as embedded, but DBW isn't, although pointing to the same
e
>> It is interesting now, that the trace works for an isql based client
>> session, even when using UTF8 as character set, but fails with e.g.
>> Database Workbench. The only difference is that isql is in the same
>> directory as embedded, but DBW isn't, although pointing to the same
>> embedded li
Hello Vlad,
>> the following is with: Firebird-2.5.2.26540-0_Win32 Embedded
>>
>> What can be the reason for the following error:
>>
>> "cannot initialize UNICODE collation to use in trace plugin"
>
> Adriano could know, i hope
>
>> when a trace session is attempted to be started with Firebir
Hello,
the following is with: Firebird-2.5.2.26540-0_Win32 Embedded
What can be the reason for the following error:
"cannot initialize UNICODE collation to use in trace plugin"
when a trace session is attempted to be started with Firebird Embedded?
As usual, Firebird Embedded is extracted into
declare your UDF with a full-qualified path (the one
above) to the UDF library dll?
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
--
> On 08/05/13 22:13, Thomas Steinmaurer wrote:
>> Hello,
>>
>> upon first usage/connect, the user is prompted with an "-Install
>> incomplete, please read chapter "Initializing security database" in
>> Quick Start Guide" message.
>>
>&g
Hello,
upon first usage/connect, the user is prompted with an "-Install
incomplete, please read chapter "Initializing security database" in
Quick Start Guide" message.
Obviously there is no QSG (or I haven't found it), so that's a bit
confusing for people being new to 3.0 (Alpha1).
Regards,
T
> i wrote this RFC by request of one local company which have (as many others)
> wrote own replicator and got some issues which could be resolved very easy
> with a little support from the Firebird engine side. I think we could discuss
> it and
> determine if requested feature could add some value
> 28.01.2013 17:27, Thomas Steinmaurer wrote:
>> How does the engine know when to garbage collect an index
>> entry?
>
> When list of record references in it is empty.
Thanks.
Regards,
Thomas
--
> On Sun, Jan 27, 2013 at 3:23 PM, Dimitry Sibiryakov <mailto:s...@ibphoenix.com>> wrote:
>
> 27.01.2013 21:17, Thomas Steinmaurer wrote:
> > Is Firebird able here to serve the result here out of the index
> or does
> > it need to lookup data
Hello,
SQL Server supports something called covering index, which basically
means, that additional columns can be added to the index definiton,
which aren't in the index key then, but at index lead level only.
I know Firebird doesn't support something like that, but I wonder if
Firebird can se
>> i move info from support list what i provide there
>> 1. I use Super Server 64 bit
>
> Certainly super does not write pages to disk as active as classic, but...
>
>> 2. DB Page Size is 16k and DefaultDBPageCache is 65536 (i disable system
>> cache in fbconfig)
>
> that's just 1Gb cache. We GC pa
> 31.10.2012 15:32, Thomas Steinmaurer wrote:
>
>> Management = Firebird Admin List?
>
> Nope, I meant just another part of my responsibilities ;-)
Ah, ok. I guess you have a bunch of hats for different roles in your
garderobe then. ;-)
>> Over all 12 years of FB development it became clear that *remaining*
>> dialect 1 users simply can't switch at all (old legacy app, they
>> certainly switch with new app. versions), so giving them another 2 years
>> inserting deprecation version before removal will not help them in any
>> signif
> 31.10.2012 12:50, Thomas Steinmaurer wrote:
>>
>>> That said, I'm against the idea in general ;-)
>
> Sorry, I had intended to write:
>
> "That said, I'm NOT against the idea in general"
Ah, even better. ;-)
> as it should obviously be wipe
> 31.10.2012 12:29, Thomas Steinmaurer wrote:
>
>>> IMHO: Dropping dialect 1 and 2 should be done with Firebird 3. People
>>> still depending on dialect 1 will then be stuck on Firebird 2.5 until they
>>> migrate to dialect 3. I think that is a better option t
> On Wed, 31 Oct 2012 08:41:39 +0100, "Paul Beach"
> wrote:
>>> I have no idea what to do (well, actually I have a very easy and good
>>> one, you know, it's to wipe dialect 1/2). I'd hate to split a single
>>> field in two to support something which should be removed +10 years
> ago.
>>
>> <> fir
> 17.10.2012 9:55, Thomas Steinmaurer wrote:
>>
>>> will the fix for CORE-3934 be available in the final 2.5.2 release?
>>
>> Any comments?
>
> I has been included there.
Great. Thanks.
Regards,
Thomas
-
Hello,
> will the fix for CORE-3934 be available in the final 2.5.2 release?
Any comments?
Thanks,
Thomas
--
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite
1 - 100 of 243 matches
Mail list logo
