Well done Set
Greetings.
Walter.
On Tue, Dec 16, 2014 at 4:30 PM, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
>
> >> I don't think there is any simple way to make a delete with a
> >> subselect as the only part of
>> I don't think there is any simple way to make a delete with a
>> subselect as the only part of a where clause perform great on
>> largish tables. That is, using EXECUTE BLOCK (which doesn't exist on
>> older Firebird versions) should perform OK:
>>
>> execute block as
>>declare variable id
Hello,
well, that's not the answer I wanted to get, but I've to deal with
that fact.
I've to check wether EXECUTE STATEMENT can execute EXECUTE
BLOCKs, as the DELETE Statement is build dynamically in a proc.
>
> Hi Björn!
>
> I don't think there is any simple way to make a dele
>Hello,
>
> Thanks for the answer.
> How can I optimize if I want to use a DML command in conjunction
> with a subselect, e.g.
>
> delete from test where Id in (
> select min(t.Id) FROM test t
> group by t.reference, t.key
> having count(*) > 1
> )
>
Hi Björn!
I don't think there is any simpl
Hello,
Thanks for the answer.
How can I optimize if I want to use a DML command in conjunction
with a subselect, e.g.
delete from test where Id in (
select min(t.Id) FROM test t
group by t.reference, t.key
having count(*) > 1
)
am Dienstag, 16. Dezember 2014 um 08:27 schrieben Sie:
Hi,
Can you provide source code with this insert action / also dfm
I have Xe7 and i can test this
About FB on DC this is one hell with Exchange. And it is much bigger problem if
you have older version of FB then 2.5.3 (may be 2.5.2 fix i do not remember) on
Win2008 with bigger then 4GB RAM
Re
SETsetknfs> One thing to notice, Olaf, is that "where cast(b.ts as
SETsetknfs> date)" will never use an index (if you have an index on
SETsetknfs> TS).
Just a note: afair, it can use an index if you have the index key
defined also as "cast(b.ts as date)".
Carlos
Firebird Performance in Detail - h
>Hello,
>
>I save values in some tables (simpler description)
>
>First a Table who saved the timestamp of the mensuration
>Table A timestamps
>ID primary key
>TS timestamp
>
>Second a Table with the measured data (25 records/measured sensors will be
>saved every 10 Minutes, one record in Table A,
no is not a problem of memory usage.
If i close the connection after 1 "insert" , then reopen the DB and keep
inserting i do not have the "memory error"
i use FIREDAC and DELPHIXE7
i am not sure if is a question of "buffering" on the FIREDAC libraries
i've opened a ticket to the FIREDAC
On Tue, 16 Dec 2014 12:00:45 +0100, "Jesus Garcia jeg...@gmail.com
[firebird-support]" wrote:
> 2014-12-16 9:39 GMT+01:00 Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] :
>>
>> My first suggestion would be to upgrade to 2.5.3 Update 1 and backup
and
>> restore your database.
>>
> Why is
2014-12-16 9:39 GMT+01:00 Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] :
>
> My first suggestion would be to upgrade to 2.5.3 Update 1 and backup and
> restore your database.
>
Why is needed to backup + restore the database when upgrade to 2.5.3. As I
know is only necessary to avoid lock
I stand corrected :) Version is 2.5.2.26540.
We have planned an update to the newest Firebird version december 25.
This database runs live and due to the christmas shopping users are online
from 6 to 23.30.And the database must not be unavailable.
So - we will wait.
Backup / Restore has
On 16 Dec 2014 00:30:18 -0800, "michael.vilhelm...@microcom.dk
[firebird-support]" wrote:
> Firebird version is: WI-V6.3.2.26540 Firebird 2.5
That is not actually a Firebird version; that is a version reported
through an old API call for Interbase compatibility. However build number
26540 sugg
Firebird version is: WI-V6.3.2.26540 Firebird 2.5
I am not very familiar with working with the Trace API at all at this point.
So this will be a later task, should I not be able to locate the problem here.
Unless you have a suggestion here?
Michael
14 matches
Mail list logo
