>>Hey,
>>not sure how you can survive with superserver :)
>>I can't see that working with our kind of load (realtime-data-processing,
>>reports, mostly write IOPS)
>>It's a long time ago (Fb 1.5) since we used superserver but we didn't have
>>the best time with it back then.
I do not know what
Hi,
1. you buffer settings is low.
you can simple calc numbers like
page_size*buffer_Size*IFTHEN(Architecture=SUPERSERVER, 1, CONNECTIONS_NUMBER) +
Temp_Cache_Limit*CONNECTIONS_NUMBER
i write from memory then someone can fix some mistakes
2. second what is your CPU usage when you compare this tw
>>1) We do monitor the transaction gab and if needed, we interact.
how often and how? By MON$ tables or you read header page?
>>2) We do run gbak daily. We do not use nbackup - we would like to and tried
>>it but it's corrupting the db.
and this slowdown is not in time of backup i suppose?
soryy not Shane but Sean
regards,
karol Bieniaszewski
>>I was not complaining about IBX nor about FB. I was just asking.
>>Embarcadero / Idera stopped developing IBX, they now support FireDAC
>>components, this is why I asked.
>>By now, replacing FB 2.5.5 with 3.0 on my test machine seems to be ok.
>>Tiberiu._,_.___
Boolean implemenatat
Hi,
this is because you use old fbclient.dll
make sure that Database Workbench use newer fbclient.dll
I do not know how Database Workbench work but maybe you have there some option
to configure client library path if not
you can copy it to the same folder as exe
regards,
Karol Bieniaszewsk
Hi,
Vlad say about RAM not HDD test
you can use for test RAM memory any tool
e.g. you can use Microsoft tool - run START type "mdsched.exe" and enter
regards,
Karol Bieniaszewski
W dniu 2016-04-22 09:14:17 użytkownik 'Christine S'
christine.sanj...@melawai.com [firebird-support]
napisał:
Hi,
as was mentioned earlier - successful backup restore did not mean that source
database was without errors.
To test source database run:
gfix -validate -full
PS. will be good to see that you have most recent version of firebird from some
part (2.1.X, 2.5.X, 3)
regards,
Karol Bienias
, liviusliv...@poczta.onet.pl [firebird-support] responded
one of possible reason is that records are not visible to transaction with this
update statement.
e.g.
1. you start transaction (tr1)
2. someone start transaction 2(tr2)
3. tr2 insert some records
4. tr1 run update
5. tr2 commit
6
Hi,
This is not specific to Firebird question but:
is something in SQL standard specification about sorted fields must be also
returned?
I mean:
SELECT
[FILM_DATE,]FILM_TITLE
FROM
FILMS
ORDER BY FILM_DATE, FILM_TITLE
is [FILM_DATE] required by SQL standard or it is optional or SQL standard
ebird-support]"
Data: 09.05.2016 13:20 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: Re: [firebird-support] SQL standard for sort fields and returned fields
On 2016-05-09 11:45, liviuslivius liviusliv...@poczta.onet.pl
[firebird-supp
Hi,
as mentioned by other - this is because of outer join
look at: http://tracker.firebirdsql.org/browse/CORE-4823
regards,
Karol Bieniaszewski
W dniu 2016-05-17 12:20:42 użytkownik agharta aghart...@gmail.com
[firebird-support] napisał:
Hi all, this is my first post and my english is bad
hi,
will be good to know which charsets did you tried. utf8, none, octets...
but remember to connet to db also with this charset settings
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "fabia...@itbizolutions.com.au [firebird-support]"
Data: 23.05.2016 03:45 (GMT
Hi,
https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/
i have few questions:
44. Use NO_AUTO_UNDO - what happend when i do rollback? I do not understand
what really do this option..
30. Use derived tables to optimize SELECT with ORDER BY/GROUP BY -
SELECT T.FIELD_KEY, T.FIELD
Hi,
thanks you and others for correction
now “44” i am near to understand.
45. i must test – but how look sort for your sample?
ORDER BY T1.iSort
and difference is because of existence of big varchar - BIGSTARTING ?
If yes then something must be wrong – this sould only sort pointers and
inrelev
Hi,
yes but this was "wrong"
Consider this:
inside procedure you have 5 different statements
and you run query and only two of them are reached - do you really need to see
all 5?
Ok - now you got only "natural" word for procedure - i do not know if this is
better now..
But if you need plan fo
ing called SP plans (SP's called by
the SP which you are converting to an execute block).
Att.
João Paulo
--
DE: "liviuslivius liviusliv...@poczta.onet.pl [firebird-support]"
Para: "fi
Hi,
what is OF and three dots after?
FOR UPDATE [OF ...]] WITH LOCK
(README.explicit_locks)
it looks like we can write after OF something more - but what?
regards,
Karol Bieniaszewski
Hi,
thanks you Paul
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Thursday, June 9, 2016 11:03 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] FOR UPDATE [OF ...]] WITH LOCK
<>
"The clause can take an optional OF to target upda
Hi,
what are + and – with working with schema?
What benefits are between
schema_name__table_name and real schema implementation?
schema_name.table_name
I near to always have worked without schema databases or with only one schema
in schema supported databases.
regards,
Karol Bieniaszewski
Hi,
test without details say nothing to me
1. Did you compare results with e.g. FB2.5 in on the same maschine with same
configuration (FBConfig)
2. What is your page size and type of HDD?
3. Do you have BOST feature enabled on CPU and HT?
4. Did you compare results on GLOBAL TEMPORARY TABLE - i
Hi,
anybody?
regars,
Karol Bieniaszewski
W dniu 2016-06-12 23:18:15 użytkownik livius
napisał:
Hi,
what are + and – with working with schema?
What benefits are between
schema_name__table_name and real schema implementation?
schema_name.table_name
I near to always have worked without sch
Hi,
do you mean that you share one connection between multiple threads?
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Wednesday, June 15, 2016 5:55 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] performance issue with firebird 3.0 emb
Hi,
thank you Dmitry – the last sentens show me some benefits
other sentenses show only complications for me.
we can write sql like
select * from table_name but really this is
select * from schema.table_name
and if i write this in stored procedure – i suppose that “object_id” will be
stored in
pluses?
Firebird has no support for schemas, IIRC... or am I missing something?
Em dom, 12 de jun de 2016 às 18:18, 'livius' liviusliv...@poczta.onet.pl
[firebird-support] escreveu:
Hi,
what are + and – with working with schema?
What benefits are between
schema_name__
Ok i then misunderstand some discussion obout increasing length of identifiers
to support then schemas
Now i understand that this is only minor preparation
regards,
karol Bieniaszewski
W dniu 2016-06-15 23:36:56 użytkownik Dmitry Yemanov
dim...@users.sourceforge.net [firebird-support]
>>In this case, user1 does not know about user2. They live in two parallel
>>universes.
>>Dmitry
Then i do not know who can take risk that user1 in one "universe" (product) at
present day have e.g. two schemas and user2 have onother schema
and in the future user2 take decision to create another
Hello Karol,
Thursday, June 16, 2016, 7:49:06 AM, you wrote:
>
> but this feature is considered for FB4 – then i need to know why this is
> important feature..
>
This whole topic is off-topic in firebird-support, which is about
current releases.
However, I'm sure others (including me) are interest
Hi,
you use wrong collation
UNICODE_CI is truly case-insensitive. In a search for e.g. 'Apple', it will
also find 'apple', 'APPLE' and 'aPPLe'.
UNICODE_CI_AI is accent-insensitive as well. According to this collation,
'APPEL' equals 'Appèl'.
as you can see UNICODE_CI_AI is accent-insensitive u
Hi,
you have right Paul and Stefan
sorry for previous answer - i miss that point
regards,
Karol Bieniaszewski
W dniu 2016-06-16 11:03:25 użytkownik Paul Vinkenoog p...@vinkenoog.nl
[firebird-support] napisał:
Hi Stefan,
> > Also, it is questionable if you should consider a and ä different
Hi,
first what i try in this situation is moving not database file only its
transportable backup and restore it on target OS.
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "Seyeong Jeong wmb...@gmail.com [firebird-support]"
Data: 21.06.2016 05:58 (GMT+01:00)
D
hi,
two things1. try latest FB version in part, you have 2.5.4 but there is 2.5.6
or newer2. 20 GB is small try to restore this db on normal PC if server have
only 20GB free.
ps. in FB3 transaction id is int64 - no more problems :)
regards,Karol Bieniaszewski
Oryginalna wiadomość
Hi,
error message?
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.com
Sent: Thursday, June 23, 2016 6:39 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] It works on FB 2.5 but does not work in FB 1.5
I created a view that works perfectly on FB
Hi,
i see in gstat output that blob pages are 0.
For every record in this table blob is not null and contain data.
I supposed that blobs are on different pages then "table Data pages" and only
id is stored within a record.
This should report then value >0?
What does it mean then "blob pages: 0
08.07.2016 15:41, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Blobs: 1976786, total length: 37039763, blob pages: 0
> Level 0: 1976786,
>> All BLOBs are level 0, they are kept on data pages with other record
>> data. No separate
>>BLOB
W dniu 2016-07-12 11:54:52 użytkownik Tim Ward t...@telensa.com
[firebird-support] napisał:
==
> CREATE TABLE TBLCSTAGASSETS
> (
> ELEMENTID BIGINT NOT NULL,
> USERID INTEGER NOT NULL,
> CONSTRAINT PK_TBLCSTAGAS
W dniu 2016-08-02 11:58:10 użytkownik Ralf Jansen ralf.jan...@mailstore.com
[firebird-support] napisał:
I just learned that enabling encryption via “ALTER DATABASE ENCRYPT etc.”
starts encryption of the database asynchronously in the background.
Are there any settings or something to chang
Hi,
is there somewhere (i look but not see) counter in MON$ tables
that count how many transactions are started by some attachement from time that
attachement has started?
or how many statements are executed/prepared during transaction?
first have bigger prioryty to me then second
regards,
W dniu 2016-08-17 11:12:01 użytkownik Köditz, Martin martin.koed...@it-syn.de
[firebird-support] napisał:
Hi all,
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
W dniu 2016-08-19 10:35:58 użytkownik michael.vilhelm...@microcom.dk
[firebird-support] napisał:
Hi
Every once in a while we need to recalculate statistics for the index.
This we do manually.
I would like to do this automatically.
Can I do this from a batch file?
Or from the command lin
Hi,
your statement is incorrect
select count(* )
should by after autonomous transaction commit not inside it
if it is in the same transaction then garbage collector cannot remove versions
and also i do not suppose that
delete from requests where created < :delete_all_before rows 1000;
is correc
Hi,
as Dmitry say problems can be already solved in snapshot build
e.g. http://tracker.firebirdsql.org/browse/CORE-5307 can be same as your
problems –
use napshot build from
http://www.firebirdsql.org/en/snapshot-builds/
regards,
Karol Bieniaszewski
From: mailto:firebird-support@yahoogroups.co
As any software FB can have bugs. You never can have 100% working software.
Because of that you need to have backup. But it contain many quality tests and
users test it also
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "fabia...@itbizolutions.com.au [firebird-supp
>
> 11.09.2016 10:29, 'Djordje Radovanovic' softsis...@sbb.rs [firebird-support]
> wrote:
> > This time instead of 1 reads of orders and 1 reads of partners I
> > received exactly
> > what I was asking for.
>
Hi,
i do not know what server do you use but if i run simple query on FB3
s
Hi,
i do not know what server do you use but if i run simple query on FB3
select
o.*
from
partners p
inner join orders o ON p.partid = o.partid
WHERE
p.country = 'Spain';
on non propagated with data tables, plan is:
PLAN JOIN (O NATURAL, P INDEX (PK_PARTNERS))
but if i fill tables with test data an
W dniu 2016-09-27 08:06:13 użytkownik Mike Ro miker...@gmail.com
[firebird-support] napisał:
On 27/09/2016 04:22, trsk...@yahoo.com [firebird-support] wrote:
Is it possible to insert image into FB database directly via sql stament using
isql or flamerobin?
Hi, yes it is possible wi
W dniu 2016-09-28 09:04:07 użytkownik 'Marcin Bury' marcin.b...@studio-delfi.pl
[firebird-support] napisał:
Hello All
I'd like to ask how to get below statement working:
SELECT A.FIELD_1, A.FIELD_2, D.FIELD_D1, D.FIELD_D2
FROM TABLE_A A
LEFT JOIN (SELECT FIRST 1 FIELD_D1, FIELD_D2 FROM TABLE_D
Kind Regards,
Arno Brinkman
ABVisie
From: liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Sent: Wednesday, September 28, 2016 12:39 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Left join derived table
W dniu 2016-09-28 09:04:07 użytkownik 'Mar
Hi,
i know
Cast('XXX' AS Integer)
but is there
try_Cast('XXX' AS Integer)
like in MSSQL?
you know if something can not by converted then return null.
regards,
Karol Bieniaszewski
W dniu 2016-10-17 10:17:33 użytkownik Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] napisał:
On 17-10-2016 10:10, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> i know
> Cast('XXX' AS Integer)
> but is there
> try_Cast('XXX' AS
hi,
maybe MERGE is your answer
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "ehmmm.fireb...@seznam.cz [firebird-support]"
Data: 19.10.2016 09:34 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: Re: [firebird-support] Optimizer request
No - you can have aplication server between to serve data to web server
and it e.g. run limited number of connection (espessialy 1 connection to
database)
and login and password can be not the db user only application user (table of
users and paswsword hash)
regards,
Karol Bieniaszewski
W
simple session id maitenanceread about
read also about No SQL databases
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "Alain Bastien alainbast...@gmail.com [firebird-support]"
Data: 28.10.2016 12:00 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: Re: {
hi,
do this in packets.delete 10 commit and then count. sleep and once again
until finished.
bu check also on Firebird 3 and tell us if your issue is still there
regards,Karol Bieniaszewski
Oryginalna wiadomość
Od: "kragh.tho...@yahoo.com [firebird-support]"
Data: 2
Hi,
i agree with you
i suppose that time spend by GC should be measured and if it take to much time
then stop GC and try again leter.
E.g. when i do delete from milions_table
and then do SELECT COUNT(*) form milions_table
it should not clear whole garbages and stop query until GC finished.
e.g.
Hi
i do not read your whole info but maybe you need to use case statement
e.g your 3 update statements can be changed fro:
Update table set prio = newprio(1) where id = 20;
Update table set prio = prio – 1 where prio < newprio;
Update table set prio = prio + 1 where prio > newprio;
to one:
Hi,
this is only for info if someone is worry about FB3 stability.
I run very big deletion statement in concurrent env - i clear 90% of old
historical data from database
and FB run without any problem this big command :)
below are stats:
Executing statement...
Statement executed (elapsed tim
Hi,
did you mean rollback? not commit?
regards,
Karol Bieniaszewski
W dniu 2016-12-14 17:44:16 użytkownik Jaume Llunell Gómez
jaumellun...@gmail.com [firebird-support]
napisał:
Hi,
is it possible to commit a transaction that is hanged in the MON$TRANSACTION
table by ID?
I've seen th
Hi,
when you migrate something and this is reserved word you name it with quotes,
and also if it contain space
but i prefer in that migration to change the name instead using double quotes.
But another place where it is vital to have double quotes supported is
select field as "some name for fiel
Hi,
"case" is function and operate on row data.
If you have 7 rows then you got 7 rows after case
To reduce rows you need to "group by"
regards,
Karol Bieniaszewki
W dniu 2017-01-05 13:12:10 użytkownik 'Stef' s...@autotech.co.za
[firebird-support] napisał:
Good day everybody,
I
Hi,
rather simple operation but can take very long time if database is big.
You can write stored procedure - or EXECUTE BLOCK
and inside iterate by system tables RDB$RELATIONS and RDB$RELATION_FIELDS
and do EXECUTE STATEMENT with where condition
and return back sum of fields '||' and table name w
Hi,
dbClick on IBTransaction component and you got Transaction editor - and there
you have all values
google for each value
regards,
Karol Bieniaszewski
W dniu 2017-01-13 07:08:19 użytkownik Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] napisał:
I am using TIBSQL, TIBDatabas
Carlos,
it was not tested because people do not know about it.
We are really interested in :)
Please announce it on the page ad you will see how big interest it take :)
regards,
Karol Bieniaszewski
W dniu 2017-01-16 15:05:06 użytkownik 'Carlos H. Cantu' lis...@warmboot.com.br
[firebird-s
Hi,
have you something like QuickStartGuide? :)
regards,
Karol Bieniaszewski
W dniu 2017-01-16 18:29:50 użytkownik peshk...@mail.ru [firebird-support]
napisał:
FB 3.0.0: http://web.firebirdsql.org/download/prerelease/android/
Not new but should be enough to begin
Hi,
this is offtopic but...
Is there any particular reason to not use always unique constraint instead of
unique index?
Some overhead? Some speed difference in insert,update,delete?
Or this is only to disable creating FK on such fields included in index but not
as constraint?
regards,
Karol
Do you have also Interbase instaled there?
regards,
Karol Bieniaszewski
W dniu 2017-02-01 19:44:48 użytkownik 'Mark Rotteveel' m...@lawinegevaar.nl
[firebird-support] napisał:
Please send your question to the Firebird-java list instead. If you do that,
make sure to include more informati
Good point about expression index :)
but i am talking generally (ommit expression index)
regards,
karol Bieniaszewski
W dniu 2017-02-03 08:05:45 użytkownik ma_go...@yahoo.com [firebird-support]
napisał:
Hi!
You cannt have expression in unique key, but you can have expression index with
un
Hi,
Firebird3
SELECT FIRST 1 S.SENSOR_UID, S.NAZWA, SD.ID, SD.ID_SENSOR, SD.DT, SD.WARTOSC,
SD.FLAGS
FROM SENSOR_DATA SD
INNER JOIN SENSOR S ON S.ID=SD.ID_SENSOR
WHERE S.ID=1
ORDER BY SD.ID DESC
plan is "wrong"
PLAN SORT (JOIN (S INDEX (PK_SENSOR), SD INDEX (FK_SENSOR_DATA__SENSOR)))
Execut
Hi Dmitry,
current snapshot: WI-V3.0.2.32691 Firebird 3.0
CREATE UNIQUE DESCENDING INDEX IXDU_SENSOR_DATA__ID ON SENSOR_DATA (ID);
ID bigint
selectivity
PK_SENSOR ASC ID 0.25
UK_SENSOR__SENSOR_UID ASC SENSOR_UID 0.25
FK_SENSOR_DATA__SENSOR ASC ID_SENSOR 0.25
IXDU_SENSOR_DATA_
Hi,
you can use Firebird embeded – it work near on every hostings
i use Firebird embeded with ASP .Net from 1.1 version
regards,
Karol Bieniaszewski
From: 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Sent: Saturday, February 18, 2017 7:06 AM
To: Dimitry Sibiryakov s...@ibphoenix.com [fireb
>>I will think a little bit more, maybe some clever idea will come.
fingers crossed
regards,
Karol Bieniaszewski
From: Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
Sent: Friday, February 17, 2017 7:38 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: F
7;t use it
with Asp Core :(
From: "'livius' liviusliv...@poczta.onet.pl [firebird-support]"
To: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]"
Sent: Saturday, February 18, 2017 9:23 PM
Subje
>>Separately, I am not aware that FireMonkey/Delphi can be deployed as mobile
>>apps if they require external DLLs. AFAIR, FireMonkey apps must be built from
>>"native" code.
FireMonkey apps are builded into native code. Firemonkey can work with external
dll
but i do not know if FBclient for An
particullary filter
data then it should be prefered :)
regards,
Karol Bieniaszewski
From: 'livius' liviusliv...@poczta.onet.pl [firebird-support]
Sent: Saturday, February 18, 2017 8:30 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re: Firebird 3 execution plan
Hi,
first try to upgrade to recent Firebird version
i recomend you snapshot
http://web.firebirdsql.org/download/snapshot_builds/win/3.0/
but you can also try official
https://www.firebirdsql.org/en/firebird-3-0-2/
after that if you will have also problems – back here
regards,
Karol Bieniaszewski
Hi,
first potential thing – transaction management.
Probably you have transaction long running and it stop garbage collector to
process old record versions
Look into MON$TRANSACTIONS
regards,
Karol Bieniaszewski
From: craig_...@coxcolvin.com [firebird-support]
Sent: Thursday, May 4, 2017 7:56
Hi,
first what do you mean it contain array of boolean
you mean e.g 5 bytes and first byte is first boolean, seconf byte is second
boolean..?
And for this you probably need udf or convert to string
regards,
Karol Bieniaszewski
From: maartenjanbak...@gmail.com [firebird-support]
Sent: Thursday
To be more precised – Interbase(and IBX) support boolean datatype but only
Interbase implementation
not Firebird implementation.
regards,
Karol Bieniaszewski
From: Tony Christiansen t...@adegroup.com.au [firebird-support]
Sent: Wednesday, May 24, 2017 1:07 AM
To: firebird-support@yahoogroups.
>>At DDL time: What happens if you flip the used data types for ID/ID1?
No difference – constraint created
regards,
Karol Bieniaszewski
From: Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Sent: Monday, June 19, 2017 7:21 PM
To: firebird-support@yahoogroups.com
Subject: Re: [fireb
>>Why should it be forbidden? Not everything that's dumb is disallowed.
Because it can cause problem if someone do this not intentionally.
Also if your system must work with many databases it is then not compatibile.
(e.g. not compatibile with MSSQL)
regards,
Karol Bieniaszewski
From: Ann Ha
Hi,
>>practical benefit to breaking up triggers?
1. separate code logically like procedure
2. you can simply disable it without altering content
3. simplify editing by minimize toxicity
regards,
Karol Bieniaszewski
-Oryginalna wiadomość-
From: Gabor Boros mlngl...@bgss.hu [firebird-supp
Hi,
Is there a way to detect throught mon$ tables or trace or other way disk
operations caused by query? I see only page_reads and page_writes, page_marks,
page_fetches but how to distinguish which one:1. Page is read because missed in
cache2. Page is read/write beacause of big sort operation3.
Hi,
> 2. Page is read/write beacause of big sort operation
>> Sort IO is directed into separate temporary files and it is nor cached by
>> the engine, nor paged.
>> Unfortunately, engine doesn't collect Sort statistics.
Will be good to see this on trace output and accumulated stats on mon$tabl
Hi,
thank you Vlad for clarify
I have created ticket http://tracker.firebirdsql.org/browse/CORE-5577
regards,
Karol Bieniaszewski
From: hv...@users.sourceforge.net [firebird-support]
Sent: Thursday, July 6, 2017 12:05 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Re:
Hi,
This whole discussion is strange to me.Rename table while are pending inserts
to it?How. If statment like rename table exsist then after name has changed all
applications must be recompiled to take this new name into account. This looks
to me that discussion is not about real problem. Only a
Hi,
For point 4 simply start readonly transactionIf it raise exception you got info
about reason.Also it is good to start transaction and rollback it if you
doesn't need to modify something
Regards,Karol Bieniaszewski
Wysłano z mojego smartfonu w PLAY
Oryginalna wiadomość Od:
Hi,
put fbclient.dll / and/or/ gds32.dll into your application folder.
Remember that you need 32bit dll’s if your app is 32bit and 64bit dll if you
have 64bit app (bitness of the server does not matter)
Check if you have not Interbase installed on you computer side (some apps can
install it)
rega
Hi,
this is the feature – key is only valid(checked) for values but null is not
“value”.
This work same in all databases i have worked.
regards,
Karol Bieniaszewski
From: Paweł Świerzko p_swier...@poczta.onet.pl [firebird-support]
Sent: Wednesday, August 9, 2017 3:21 PM
To: firebird-support@ya
Hi,
will be better to show sample script
create table
and insert into..
and db charset
then anyone can test this self
regards,
Karol Bieniaszewski
From: eadbha...@yahoo.com.mx [firebird-support]
Sent: Monday, September 4, 2017 7:34 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-sup
Hi,
Run Select * from mos$transactions
Then you will see if you have long running
Regards,Karol Bieniaszewski
null
No. I only point you how to check this.
From your header you can read that oldest active and next transaction have only
5 transactions gap. Other numbers you can progress by running sweep.
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "shg_siste...@yahoo.com.ar
[firebird
> I read somewhere that the "read only" transactions are absolutelly harmless
> to the GC and sweeping. Is that so?
>>Read only transactions only physically have an impact on the TIP/Header
>>page(s), however a long running read only transaction
>>will have the same effect as a long running read
>>Karol,
>>I was referring to the default transaction state of snapshot (repeatable
>>read)
>>Other transaction states will have different effects. In your case
>>read commited needs only the newest record version (or record versions
>>created by
>>the transaction itself) so its not going t
Hi,
i do not remember your previous description
but did you checked your DB against corruption?
gfix –validate –full
any errors (also in firebird.log)?
Did you performed backup/restore process.
Do you use any udf? also system udf?
Do you have enough free mem, free disk space also for temp files l
Hi,
It is possible but you must change current thread credentials. I do not
remember now api call but look in the google for changing credential for the
thread
Regards,Karol Bieniaszewski
null
Yes,
You must first impersonate user for the current thread and then you can login
to fb from that thread
Regards,Karol Bieniaszewski
Oryginalna wiadomość Od: "'Nikolaus Kern' parzival1...@gmx.at
[firebird-support]" Data: 20.09.2017 17:10
(GMT+01:00) Do: firebird-support@yaho
Hi,
this is terible to read. Please change join style to explicite join style
instead SELECT .. FROM TABLE_A A, TABLE_B B WHERE A.ID=B.ID
write SELECT .. FROM TABLE_A A INNER JOIN TABLE_B B ON A.ID=B.ID
regards,
Karol Bieniaszewski
From: trsk...@yahoo.com [firebird-support]
Sent: Friday, Sept
Hi,
show View (M_FNGD_VW) definition
and also what are the settings – especially PAGE buffers and Page size in both
2.5 and 3
regards,
Karol Bieniaszewski
From: trsk...@yahoo.com [firebird-support]
Sent: Friday, September 22, 2017 11:05 AM
To: firebird-support@yahoogroups.com
Subject: [firebi
Hi,
look on this, only simple sample, by if join count increase you will see
difference faster.
Also faster if you join by few fields not only one.
At first look you see clearly where is filter and where is join condition.
And then you can simply analyse if query use indexes on joined fields and
Hi,
group by + havingis your friend.E.g.Select field1, field2, count(*)From
tablexGroup by field1, field2Having count(*)>1
But in your scenario i do not know if this is the solution. Question is if
record was changed and in next update "restored" and once again changed is this
duplicate or no?If
201 - 300 of 622 matches
Mail list logo
