You must call fb_shutdown before unload fbembed.dll
Regards,
Vlad
Hugo,
Switch -U[SER] set user name for autentification, i'm doubt it could address
the problem.
If .delta file was really lost, nbackup can't help. Therefore i don't think it
was lost.
Regards,
Vlad
PS Sometimes it is risky even to cross the road... especially if you know no
rules and see
Ideally, i would like to have reproducible test at my hands to analyze it.
It is possible for you to provide me with it ?
As for debug dumps you have - they can't help as produced *after* deadlock
condition was found and cleaned by Lock Manager.
Thanks,
Vlad
No ths is not related to subject, this is another issue.
I have few such reports from customers but without test case to reproduce it.
I suspect this is related to garbage collection of a very long versions chain
(ten's backversions for the same record).
gstat -r could confirm it.
Regards,
Win32 error 193 is:
ERROR_BAD_EXE_FORMAT 193 (0xC1) %1 is not a valid Win32 application.
Very strange... probably issues with antivirus\firewall ?
Regards,
Vlad
---In firebird-support@yahoogroups.com, henkcats@... wrote :
Hi,
From a certain moment the message 'Connection rejected
John,
Upgrade to 2.5.3, and read Release Notes carefully
Regards,
Vlad
PS there is no such version as 2.5, there are five releases in 2.5.x series
Alex,
what is limit of 2.083.888 kb ?
Is it size of database file on disk ?
Is it memory usage by Firebird process (what exact memory counter) ?
Something else ?
How do you insert blobs into database ?
Regards,
Vlad
---In firebird-support@yahoogroups.com, af_123xy@... wrote :
Hi all
i
No
Regards,
Vlad
---In firebird-support@yahoogroups.com, af_123xy@... wrote :
out of memory inserting the Blob
is there any difference betwern 32 and 64 FB engine about db size limit
(supposing that i am on a NTFs (5) filesystem) ?
Update, internally, consists of following steps (simplified) :
1. read record
2. evaluate new record
3. write new record into data page
really, it is a more complex, but for now we interesting only in steps above.
At step 1, read-committed (RC) transaction waits for commit or rollback of
Walter,
there are few reasons:
a) MVCC engine never block records - it just can't :)
b) the only way to disable concurrent updates of the same record is... update
:)
More exactly: engine must mark primary record version by current transaction
and
it will make concurrent writes wait or
Hi, André !
[Old]
Server 2003 x86 no service packs
Xeon with 4 GB RAM
Classic 1.5.4 (x86, of course)
Raid 0 on 2 * 500 GB SAS (though this is from memory, I should look it up...)
[new]
Server 2008 R2 x64 SP1
Xeon with 8 GB RAM (I will shortly add +8)
Classic 2.5.3 x64
Raid 0 on 3 *
Tim,
your question:
(iii) I can't find any documentation of when the connection on database
B get closed, and when and under what circumstances the transaction on
database B gets committed and when and under what circumstances it gets
rolled back
documentation
Read the documentation first
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-psql-execstat.html
http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-psql-execstat.html
Regards,
Vlad
With CS, when you stop listener process all working processes are still works.
Clients connections are not lost and alive.
Regards,
Vlad
---In firebird-support@yahoogroups.com, tdw@... wrote :
If SET STATISTICS is done on one connection, when does it take effect?
As any DDL statement it actually runs at transaction commit.
What about a transaction that was already running at the time someone
else did SET STATISTICS,
---In firebird-support@yahoogroups.com, listas@... wrote :
Re: [firebird-support] Re: Plan question, what is a stream and what isn't?
Note, stored procedures and triggers are prepared\optimized once when
loaded into metadata cache.
Regards,
Vlad
Just by curiosity, when are
---In firebird-support@yahoogroups.com, tdw@... wrote :
On 15/04/2015 18:50, hvlad@... mailto:hvlad@... [firebird-support] wrote:
---In firebird-support@yahoogroups.com
mailto:firebird-support@yahoogroups.com, listas@... mailto:listas@... wrote :
Re: [firebird-support] Re: Plan
---In firebird-support@yahoogroups.com, dressel@... wrote :
We are considering moving from 1.5x to 2.5x. 95% of our user base is using
FB embedded (using Delphi and IBO) . We have a few thousand
installs on Windows and it could be quite painful if this doesn't go
smoothly--like sinking
---In firebird-support@yahoogroups.com, joja.lists@... wrote :
Reproducible test case would be ideal
Hello Vlad, hello Alexey, and other interested people!
I have prepared a test case now showing the memory leak with a simple fresh
database and many many connect / select / disconnect
---In firebird-support@yahoogroups.com, hvlad@... wrote :
Could you register it a tracker, please ?
Done: http://tracker.firebirdsql.org/browse/CORE-4830
http://tracker.firebirdsql.org/browse/CORE-4830
Regards,
Vlad
---In firebird-support@yahoogroups.com, joja.lists@... wrote :
Any hints how to investigate this problem?
Reproducible test case would be ideal
Regards,
Vlad
---In firebird-support@yahoogroups.com, joja.lists@... wrote :
Sorry, I didn’t check my mail till now. Thank you for creating the ticket.
And of course for fixing the bug.
Please, verify it using recent snapshot build
Regards,
Vlad
---In firebird-support@yahoogroups.com, ts@... wrote :
Is this SuperServer only or also SuperClassic?
SuperServer only.
Regards,
Vlad
---In firebird-support@yahoogroups.com, jackmason@... wrote :
Thanks. We do have both Interbase and Firebird running on our Win7 machine
because we have to access both types of databases. I will try your
suggestion.
Any news on this issue ?
Regards,
Vlad
---In firebird-support@yahoogroups.com, jackmason@... wrote :
Is this what you needed?
Hmm... i'd say it is impossible to obtain such results using FIrebird. See
below
C:\Program Files\Firebird\Firebird_2_5\binisql -user sysdba -pass masterkey
Use CONNECT or CREATE DATABASE to
---In firebird-support@yahoogroups.com, hvlad@... wrote :
---In firebird-support@yahoogroups.com, jackmason@... wrote :
Hmm... i'd say it is impossible to obtain such results using FIrebird. See
below
C:\Program Files\Firebird\Firebird_2_5\binisql -user sysdba -pass
masterkey
Use
---In firebird-support@yahoogroups.com, shg_sistemas@... wrote :
BARO (Client) Tue May 12 12:20:20 2015 C:\Program
Files\Firebird\Firebird_2_5\bin\fbserver.exe: terminated abnormally
(4294967295)
It means that Firebird crashes, unfortunately. Could you provide me with full
memory
---In firebird-support@yahoogroups.com, joja.lists@... wrote :
I'm facing a problem where the firebird server v2.5.4 on win 2012 server in
superserver mode is leaking memory. Currently I'm at ~5GB usage.
1. Show us results of
select count(*) form mon$attachments
select count(*) form
---In firebird-support@yahoogroups.com, vncastanheira@... wrote :
It should be a nbackup file since it has .nbk extension
Strong proof :-)
and created by a tool that uses nbackup.
What tool ? How it is uses nbackup ?
Is it possible to recover it, if corrupted?
I don't know.
---In firebird-support@yahoogroups.com, vncastanheira@... wrote :
I'm trying to restore a backup lvl 0, but encountering the following error:
Failure: Cannot get backup guid clumplet from I.O backup
There's no place where this error gets reported and I'm unable to figure out
the
---In firebird-support@yahoogroups.com, ts@... wrote :
From a throughput perspective, this would mean:
IB XE3 = 0,918 MB/s
IB XE7 = 1,896 MB/s
FB 3 = 3,282 MB/s
To be honest, astonishing low numbers in 2015, for all three.
To be even more honest, measure time of restore without
---In firebird-support@yahoogroups.com, jackmason@... wrote :
The databases reside on a Linux Mint server, but we back them up to a
Windows 7 system. Both are running the same release of Firebird.
Are you sure you run Firebird 2.5 on Win7 (not 2.1) ?
Please, run following in command
Rajiv,
there is already a field named SEC$NAME_PART in ODS12 system tables.
You should rename your field\domain in source database in order to restore it
in FB3.
Regards,
Vlad
> ---In firebird-support@yahoogroups.com, wrote :
> > On 13/11/15 14:22, hvlad@... mailto:hvlad@... [firebird-support] wrote:
> > Patch was updated but not announced:
> >
> > http://web.firebirdsql.org/download/sphinx/
> > http://web.firebirdsql.org/download/sphinx/
> >
> > You
> ---In firebird-support@yahoogroups.com, wrote :
>
> Seems that patch with a little tweaks in configure scripts can be applied to
> 2.2 branch >
> https://github.com/sphinxsearch/sphinx/pull/10
> https://github.com/sphinxsearch/sphinx/pull/10 >
> configure part works i
---In firebird-support@yahoogroups.com, wrote :
On 13/11/15 14:22, hvlad@... mailto:hvlad@... [firebird-support] wrote:
> Patch was updated but not announced:
>
> http://web.firebirdsql.org/download/sphinx/
> http://web.firebirdsql.org/download/sphinx/
>
> You should get
---In firebird-support@yahoogroups.com, babak_bsn@... wrote :
I would like to trace data base activity in fire bird using Audit/Trace
Services. I run this command in my command prompt:
C:\Program Files\Firebird\Firebird_2_5\binfbtracemgr -se
localhost/3050:service_mgr -user SYSDBA
Patch was updated but not announced:
http://web.firebirdsql.org/download/sphinx/
http://web.firebirdsql.org/download/sphinx/
You should get Sphinx sources, apply patch and make by yourself on CentOS
Good luck,
Vlad
> ---In firebird-support@yahoogroups.com, wrote :
> > I discovered something else quite interesting: >
> I realized both IB and FB dbs have pagebuffers set to 100.000. I changed FB
> to 0 and now it works like I
> expected!!..Same query now completes on FB on 50 sec. It seems
> ---In firebird-support@yahoogroups.com, wrote :
> > Hello,
>
> I need to rebuild some records in my database. I have to choices:
>
> 1. Firstly I delete set of records and then insert new ones.
> 2. I update the existing ones.
>
> What solution is preferable? Will
> ---In firebird-support@yahoogroups.com, wrote :
> > I'm using Firebird 2.5.x and the command gfix -v -full returned:
>
> Summary of validation errors
>
> Number of record level errors : 3
> Number of database page errors : 1993
>
> What I have to do in order to fix it,
> ---In firebird-support@yahoogroups.com, wrote :
> > Hi Vlad, thank for your e-mail!
>
> I understood what you said, however, in the link
> http://www.firebirdsql.org/manual/gfix-dbverify.html
> http://www.firebirdsql.org/manual/gfix-dbverify.html I got the following
>
---In firebird-support@yahoogroups.com, wrote :
> On 18-9-2015 19:50, amigoface@... mailto:amigoface@... [firebird-support]
> wrote:
> > i have problems on using firebird embedded on my asp.net web host .
> >
> > everything work fine locally but on the web i have an exception
>
> ---In firebird-support@yahoogroups.com, wrote :
> anyway, since i cannot control where fbembedded put it's lock and trace
> files,
Does you read what Mark wrote about FIREBIRD_LOCK environment variable ?
> my only option now is to build firebird from source and change
Quick look at sources show that
1. isc_event_block\gds__event_block and isc_event_counts\gds__event_counts make
assumption that event name length is 1-byte wide,
i.e. it encode\decode event into\from event blocks using 1-byte length for
names.
This give us up to 255 bytes for name string.
2.
> ---In firebird-support@yahoogroups.com, wrote :
> > Monday, November 30, 2015, 7:40:50 PM, Thomas Steinmaurer wrote:
> > That information is also available on the database header page,
> > which can be extracted by gstat -h
> Unfortunately, that information is absent from
> ---In firebird-support@yahoogroups.com, wrote :
> > Using Database Workbench I added a trigger to a table, but it didn't
> seen to do anything (in particular didn't throw an exception which it
> should have done when I deliberately created an invalid record).
>
> After restarting
---In firebird-support@yahoogroups.com, wrote :
http://tracker.firebirdsql.org/browse/CORE-5210
http://tracker.firebirdsql.org/browse/CORE-5210
http://tracker.firebirdsql.org/browse/CORE-5210
[#CORE-5210] Firebird 3.0 + fbclient 3.0 - POST_EVEN...
> ---In firebird-support@yahoogroups.com, wrote :
> > Something funny is going on regarding the memory consumption, I have
> > attached screenshots showing the memory counters.
> If you look at the process itself (file
> TaskManager_Process_Firebird_Only_Consumed_2GB.jpg), it
> ---In firebird-support@yahoogroups.com, wrote :
>> Setting DefaultDbCachePages more than allowed caused a crashed.
> Try a v3.0.1 snapshot build, IIRC it was fixed recently.
If you mean CORE-5240 - it was a bug in v 2.5 only, i.e. v3 is not affected
Regards,
Vlad
> ---In firebird-support@yahoogroups.com, wrote :
>
> Hi guys,
>
> Am I correct that maximum allowed RAM for database cache on SS FB 3.0 in
> Win64 is only 2 GB?
> Calculated from max DefaultDbCachePages (131072) x max Page Size (16384) = 2
> GB.
No. This is limit for
---In firebird-support@yahoogroups.com, wrote :
> "C:\Program Files\Firebird\Firebird_3_0\gbak.exe" -b -v -t -se service_mgr
> employee e:\xxx.bak -user SYSDBA > works if no one is connected else i
> always get error "file is used by another process".
Specify remote
---In firebird-support@yahoogroups.com, wrote :
...
> The setting we are playing with are:
>
> On firebird.conf
>
> FileSystemCacheThreshold = 0
> FileSystemCacheSize = 17179869184 (this is 16 GB - the server has 32 GB
> ram.)
Does you ever read comments describing this
---In firebird-support@yahoogroups.com, wrote :
> yes, one connection per database, any thread needs to access this database
> would
> create its own transaction.
Then you have serialization at connection level. Both engine and remote layer
doesn't allow to run more than
---In firebird-support@yahoogroups.com, wrote :
> Hi,
> In which version of Firebird (if in any) was fixed Borland Interbase 2007
> Integer Overflow bug.
> Links:
> http://www.securityfocus.com/bid/29302/discuss
> http://www.securityfocus.com/bid/29302/discuss
It is easy to
Hi Alex,
try http://web.firebirdsql.org/download/sphinx/2.2.10/
http://web.firebirdsql.org/download/sphinx/2.2.10/
Regards,
Vlad
PS I was sure official site is updated with links to this build...
> ---In firebird-support@yahoogroups.com, wrote :
> > Hi Vlad,
>
> Thanks a lot. Can you by chance rebuild it with -id64 support or it will be
> too much of a hassle?
-id64 is already ON by default, see
> ---In firebird-support@yahoogroups.com, wrote :
> > Hi Vald,
>
> That was what I tried first, but unfortunately this build will not run on
> Windows Server 2003.
Got it. It doesn't run on W2K3 because VS 2013 doesn't support XP\W2K3 by
default.
I'll re-build it a bit
> ---In firebird-support@yahoogroups.com, wrote :
> > If we dismiss rfunc.dll because it has bugs then I mention ib_udf.dll (the
> > one with FB2.x) and freeUDFLib.dll (that works under FB2.x).
> Both dlls install into fb3rc2. Both fail in the manner I described. So what
> is
If your application not see such error - don't worry. Sooner of all it is
related with prefetch logic by
network server and handled by it internally.
Regards,
Vlad
> ---In firebird-support@yahoogroups.com, wrote :
> > Seems like I cannot use Firebird embedded on an IIS webserver via ISAPI. >
> > I am using Delphi REST server.
>
> Please help if it is possible.
Seems you forgot to describe exact problem
Regards,
Vlad
> ---In firebird-support@yahoogroups.com, wrote :
> > I believe you mentioned earlier that you were testing FB3 RC2 on a fresh
> install. Maybe the old UDFs require the presence of the Microsoft Visual
> Studio 2005 C runtime (msvcr8), while Firebird only provides the
> Microsoft
Karol,
if you worry about database size after update, i could suggest to split huge
update
by few smaller, each in own transaction and garbage collect between passes.
I.e. something like
update t set ... where id between 0 and N;
commit;
select count(*) from t where id between 0 and N;
commit;
---In firebird-support@yahoogroups.com, wrote :
Your glibc seems ok (a bit outdated, but not critical)
> 4. MemTotal: 7911216 kB (8 GB)
I mean - could you run memory test to ensure your RAM is ok ?
Random corruptions of different databases could be sign of
> ---In firebird-support@yahoogroups.com, wrote :
Christine
>
> Did anyone ever face this error when gbak ?
>
> gbak: ERROR:internal Firebird consistency check (decompression overran
> buffer (179), file: sqz.cpp line: 239)
> gbak: ERROR:gds_$receive failed
>
---In firebird-support@yahoogroups.com, wrote :
> I'm using the Firebird 3.0 release version. Delphi 10.1 Berlin with the
> firebird.pas release file and fbclient3. I can connect to the database
> and can run queries, but I can't seem to get a custom transaction parameter
Christine,
few questions:
- am i correctly understand that you have few different DB's and all of them
corrupted ?
- does you use 32-bit or 64 bit build of Firebird and CentOS (i686 or x64)?
- what is glibc version ?
- could you check memory on server machine ?
Regards,
Vlad
Could you try latest snapshot build of 3.0.1 ?
Regards,
Vlad
---In firebird-support@yahoogroups.com, wrote :
Mark, your answer as usual very detailed and very good, i just want to
correct it a bit.
>> /1. //POS003 (Server) Fri Jul 15 11:56:32 2016/
>>
>> / Database: C:\GASTRO.FDB/
>>
>> / Index 6 is corrupt (missing entries) in table
---In firebird-support@yahoogroups.com, wrote :
...
> Before making repair the database checked the database are logged 2 users
> SYSDBA (server and client). In this case,
> the command gfix not block access to the database - not disconnect the user
> SYSDBA client. ...
>
> ---In firebird-support@yahoogroups.com, wrote :
>
> I can create triggers in the MON$ATTACHMENTS table?
No
> I use Firebird 2.5.6 with flamerobin
>
> I want to do something like "After Delete"
> delete from table1 where con = old.MON$ATTACHMENT_ID
RTFM: Database triggers
---In firebird-support@yahoogroups.com, wrote :
> Need to come back to this. I can reproduce the behavior with flamerobin as
> client.
> Connect via the embedded client to a database start encryption, disconnect. I
> can see that a handle to the database
> is still opened by
---In firebird-support@yahoogroups.com, wrote :
> my Database isn’t reachable for short times. This happens once in a few
> days. The firebird.log shows following messages: > linux-j4zt Wed Aug
> 17 10:59:58 2016
> /usr/sbin/fbguard: /usr/sbin/firebird
---In firebird-support@yahoogroups.com, wrote :
Hello everybody
If I connect to a database "Database1" using ISQL, I can write something like:
OUTPUT MyFile.DAT;
SELECT * FROM MyTable;
OUTPUT;
And all the rows of "MyTable" will go to the text file
---In firebird-support@yahoogroups.com, wrote :
> I've started looking into Firebird tracing capabilities and there seems to
> be very little documentation on the topic besides the official manual and
> a few commercial applications that are well known.
Does you read
---In firebird-support@yahoogroups.com, wrote :
> I am facing a DB corruption issue on firebird database. Everytime my
> application tries to open connection or perform any DML activities,
> randomly i get the following error.
So, everytime or randomly ?
> ERR::I/O error
---In firebird-support@yahoogroups.com, wrote :
...
> Now I have a couple of questions for you: >
> 1. Do you know if it is possible in gsec to log in under a custom ROLE?
Sure, it is possible
> Further to this, is there a way of GRANTing the custom ROLE the
A little sample with Firebird 2.5
I added ordinary users 'user1' and 'user2' and admin user 'adm1'.
Now try to display list of users
1. Use sysdba account:
firebird\bin>gsec -user sysdba -pass masterkey -display
user nameuid gid admin full name
---In firebird-support@yahoogroups.com, wrote :
> Killing connections by deleting from MON$STATEMENTS requires Firebird
> 2.5 and an ODS 11.2 database (so you will also need to backup and
> restore the database when migrating to Firebird 2.5!).
MON$ATTACHMENTS ;)
Regards,
Vlad
---In firebird-support@yahoogroups.com, wrote :
> In a production environment using Firebird v2.5, we need to delegate
> authority of USER CRUD operations to more than one person without these
> admins sharing the SYSDBA user and password.
Does you read this chapter
> In which DLL are the isc_action_svc_trace_* functions located? I am
> planning to call it from a Lazarus project
As i already wrote, you should work with Services API. If you never works
with it before i suggest to
read IB6 "API Guide"
https://www.firebirdsql.org/en/reference-manuals/
Fabian,
run gbak using services (with -se switch)
Vlad
PS overquoting is BAD
---In firebird-support@yahoogroups.com, wrote :
> I am getting this error while running nbackup:
>
> "nbackup needs local access to database file"
>
> The nbackup sentence is:
>
> Nbackup.exe -user SYSDBA -pas HereMyPass -B 0 localhost:MyDB_FB3.fdb
>
> ---In firebird-support@yahoogroups.com, wrote :
> > Hi guys,
>
> Anyone here able to connect to FB 3.01 with JDBC 2.x?
>
> I have tried with jaybird-full-2.2.11 & have adding these lines to
> firebird.conf
> 1) UserManager = Srp, Legacy_UserManager
> 2) AuthClient = Srp,
> ---In firebird-support@yahoogroups.com, wrote :
>
> We noticed the results of restoring with NBackup a 7 Gb database is 50
> megabytes shorter in size than the original DB. Is this a problem? Or it
> does not matter? Both Db are equal?
Engine expands database file by
> ---In firebird-support@yahoogroups.com, wrote :
> > Hi
> What;s requred for the Windows app to access a remote Firebird database ?
> The minimal installation
...
> 3. The icu* libraries, the same bitness as your application
Client not used ICU. It is required for embedded,
---In firebird-support@yahoogroups.com, wrote :
> From time to time, when I try to alter a stored procedure in a
> production database, I get "object in use" error.
Run DDL statement in wait transaction. Better to set some timeout to not wait
too much, but not no-wait
---In firebird-support@yahoogroups.com, wrote :
> Pagesize is 16384
It is OK
> and pagebuffers is 256.
It is *terrible* ! Set it to 1024 and look what happens
> Servermode is superclassic.
Not matters in this test
> If I drop the primary key/index everything
---In firebird-support@yahoogroups.com, wrote :
> I have finally had some more time to look into the problem I have been
> having, and have isolated and
> reproduced the problem. The cause of the problem seams to be a Varchar(36) ID
> column containing a
> guid/uuid.
---In firebird-support@yahoogroups.com, wrote :
As said I was a little unclear in my first post, my problem is not to create
the autoincrementing field which most of your replies is about but to handle
existing table entries. (Neither will I use the rdb$db_key for
---In firebird-support@yahoogroups.com, wrote :
>> Here you delete some records, but then count whole table.
>>Add same "where" condition as in "count" query
>
> I think the execution of select count is for garbage collection.
Sure
> If count of records that does not exists is
> ---In firebird-support@yahoogroups.com, wrote :
> > Hey Vlad > If i only count the deleted rows, the problem is the same, and
> > the server hangs while performing garbage collection.
Sad. Probably, table have a lot of indices ? IO subsystem, amount of RAM,
page size
---In firebird-support@yahoogroups.com, wrote :
Hey
I have a database that needs some cleanup, in some tables i need to delete
millions of rows. I performed the cleanup on a copy of the production database
in a development environment, using:
delete from table where
---In firebird-support@yahoogroups.com, wrote :
> When I run GSTAT with the switch -data it shows me numbers after "data
> pages" and "data page slots". >
> Usually these numbers are the same, but ... what happen when they are
> different?
Physical numbers
---In firebird-support@yahoogroups.com, wrote :
>
> I am trying to create or modify the following procedure:
>
> create or alter procedure test_procedure(id integer, p_from_date date)
> as
>
> declare variable from_date date;
> declare variable to_date date;
>
>
---In firebird-support@yahoogroups.com, wrote :
> In my box in isql mode ( win7_x64, dedicated ssd drive for databases)
> default db configuration
>
> is still difference between 2.5 and 3.0:for select first 100 *
> (now over 100% of time fb 2.5)
>
>
> //2.5
> SQL>
---In firebird-support@yahoogroups.com, wrote :
> In my box in isql mode ( win7_x64, dedicated ssd drive for databases)
> default db configuration
>
> is still difference between 2.5 and 3.0:for select first 100 *
> (now over 100% of time fb 2.5)
Try Firebird 3.0.2
---In firebird-support@yahoogroups.com, wrote :
> Are ther other possibilities to set the Firebird path than setting
> %FIREBIRD%? A parameter to attachDatabase() maybe?
SetEnvironmentVariable.
---In firebird-support@yahoogroups.com, wrote :
On 10.03.2017 15:35, hvlad@... mailto:hvlad@... [firebird-support] wrote:
> So setting FIREBIRD environment variable is the correct and only way to
> define the Firebird/plugin path at runtime?
Correct - yes, only - no
---In firebird-support@yahoogroups.com, wrote :
Hi,
> fb 2.5.7.27050_0_x64
> fb 3.0.1.32609_0_x64
>
> same table and data:
>
...
>
> select count(*) from t1
>
> //FB 2.5 time 4 sec.
> //FB 3.0 time 6 sec
>
> //now select first 1 mln recs order by id desc
>
> select
1 - 100 of 192 matches
Mail list logo