Hello,
I would like to save the old records in a separate table every year. On the
end of the year I would Copy the empty main-table to an new table named like
"Backup" and the old year for example. The new backup table needs no
triggers.
How can I realize this?
Thanks.
Best regards
Den 2012-06-12 10:36 skrev Olaf Kluge såhär:
>
> Hello,
>
> I would like to save the old records in a separate table every year.
> On the
> end of the year I would Copy the empty main-table to an new table
> named like
> "Backup" and the old year for example. The new backup table needs no
> trigg
Hello,
> > Hello,
> >
> > I would like to save the old records in a separate table every year.
> > On the
> > end of the year I would Copy the empty main-table to an new table
> > named like "Backup" and the old year for example. The new backup table
> > needs no triggers.
> >
> > How can I realize
> I would like to save the old records in a separate table every year. On the
> end of the year I would Copy the empty main-table to an new table named like
> "Backup" and the old year for example. The new backup table needs no
> triggers.
>
>
>
> How can I realize this?
Are you curious about the:
>>> Hello,
>>>
>>> I would like to save the old records in a separate table every year.
>>> On the
>>> end of the year I would Copy the empty main-table to an new table
>>> named like "Backup" and the old year for example. The new backup table
>>> needs no triggers.
>>>
>>> How can I realize this?
On Tue, 12 Jun 2012 10:36:57 +0200, "Olaf Kluge"
wrote:
> Hello,
>
> I would like to save the old records in a separate table every year. On
the
> end of the year I would Copy the empty main-table to an new table named
> like
> "Backup" and the old year for example. The new backup table needs no
Hi Thomas,
>>> Hello,
>>>
>>> I would like to save the old records in a separate table every year.
>>> On the
>>> end of the year I would Copy the empty main-table to an new table
>>> named like "Backup" and the old year for example. The new backup table
>>> needs no triggers.
>>>
>>> How can I re
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
wrote:
>
> > >Hi, I'm jimmy
> >
> > Hi Jimmy!
> >
> > > I have a problem, please help me!
> > > I have a table with 3,000,000 rows record, every row update 1 to 5 times
> > > in one day.
> > > The speed of update statement become
Hello Mark,
>If it is just for backup, why not just create a single backup table and
>move all records into that table at year end. Then there is no need to
>create a table per year (and it is easier to provide a unified view on
>’archived' records).
>
>Mark
my apprehension is that the querie
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
wrote:
>
> > >Hi, I'm jimmy
> >
> > Hi Jimmy!
> >
> > > I have a problem, please help me!
> > > I have a table with 3,000,000 rows record, every row update 1 to 5 times
> > > in one day.
> > > The speed of update statement become
> --- In firebird-support@yahoogroups.com, Svein Erling
> Tysvær wrote:
>>
Hi, I'm jimmy
>>>
>>> Hi Jimmy!
>>>
I have a problem, please help me!
I have a table with 3,000,000 rows record, every row update 1 to 5 times
in one day.
The speed of update statement become slow
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
>
> > --- In firebird-support@yahoogroups.com, "Fabiano" wrote:
> >>
> >> What frequency do you backup/restore this database?
> >> This database can not stop, It used to realtime collect data.
> >so no restore only backup, b
sorry, everybody!
my english is so bad, maybe can not describe clearly.
:)
> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
>>
>>> --- In firebird-support@yahoogroups.com, "Fabiano" wrote:
What frequency do you backup/restore this database?
This database can not stop, It used to realtime collect data.
>>> so no restore only backup
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
>
> > --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
> >>
> >>> --- In firebird-support@yahoogroups.com, "Fabiano" wrote:
>
> What frequency do you backup/restore this database?
> This databa
> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
>>
>>> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer wrote:
> --- In firebird-support@yahoogroups.com, "Fabiano"
> wrote:
>>
>> What frequency do you backup/restore this database?
>> T
Den 2012-06-12 11:18 skrev Olaf Kluge såhär:
>
> Hello Mark,
>
> >If it is just for backup, why not just create a single backup table and
> >move all records into that table at year end. Then there is no need to
> >create a table per year (and it is easier to provide a unified view on
> >’archived'
Hello,
I created the following stored procedure:
create procedure P_DB_MOVE_RECORDS (
TOID integer)
as
declare variable STR_J char(4);
declare variable STMTXT varchar(300);
declare variable CHKPROZ integer;
begin
for select substring(ts from 1 for 4) as tsz from t_dt where lnr
How can I commit the DDL-Procedure that the oter find my table?
Hello,
I created the following stored procedure:
create procedure P_DB_MOVE_RECORDS (
TOID integer)
as
declare variable STR_J char(4);
declare variable STMTXT varchar(300);
declare variable CHKPROZ integer;
begin
for sele
Hi Thomas and thanks for trying to help me.
To answer your questions:
> * What's the read/write ratio in your test?
The ratio is around 1.33 read statement per write statement
> * Any special reason to lock the entire table for write operations? I
> guess that's PROTECED WRITE supposed to do
I've been muddling my way through a build of the ODBC driver on OSX. After some
work I was able to find and build all the required prerequisite files, change
some paths, move a few things around, and presto, one Mac driver. However,
attempting to connect using it fails with:
dlopen(libfbclient.
--- In firebird-support@yahoogroups.com, "anthonyjang2012" wrote:
> The issue occurred again, but, unfortunately, we only obtained a full dump.
> The full dump is 8GB (1GB zipped). Would this be useful to send to you?
> Please let me know so that I can put it on an ftp site for you to download
> … How can I commit the DDL-Procedure that the oter find my table?
You can't COMMIT in PSQL. What you could try is to encapsulate your
stuff in an AUTONOMOUS TRANSACTION (available in Firebird 2.5), but I
haven't tried if this works in a scenario where you create a table and
insert into that t
23 matches
Mail list logo