Hi,

informix 7.31fc6
Using Informix Enterprise Command Center SQL Editor 3.01.TC1
I want to query 2 tables, a history table and a planned table.
select * from history where date >= ("17/11/2005");
select * from planned where date >= ("17/11/2005");

Both selects take 5 minutes.
The application is continuously running, moving entries from planned to
history.
How to make sure that I don't miss any entries, or have some doubles?

TIA,

Daniel

to ensure you don't miss any rows or have any duplicates you need to
lock both the lock the tables in exclusive mode before you do the
select

you may also want to consider

select * from history where date >=("17/11/05")
union
select * from planned where date >=("17/11/05")

but I am not sure if a row is moved from history top planned wheile
this select is running that you could guaranetee you didn't miss it



ECS wrote:
> Hi,
>
> informix 7.31fc6
> Using Informix Enterprise Command Center SQL Editor 3.01.TC1
> I want to query 2 tables, a history table and a planned table.
> select * from history where date >= ("17/11/2005");
> select * from planned where date >= ("17/11/2005");
>
> Both selects take 5 minutes.
> The application is continuously running, moving entries from planned to
> history.
> How to make sure that I don't miss any entries, or have some doubles?
>
> TIA,
>
> Daniel

Thanks, this seems to work

"scottishpoet" <dryburghj@yahoo.com> schreef in bericht
news:1132229696.669169.116400@f14g2000cwb.googlegr oups.com...
> to ensure you don't miss any rows or have any duplicates you need to
> lock both the lock the tables in exclusive mode before you do the
> select
>
> you may also want to consider
>
> select * from history where date >=("17/11/05")
> union
> select * from planned where date >=("17/11/05")
>
> but I am not sure if a row is moved from history top planned wheile
> this select is running that you could guaranetee you didn't miss it
>
>
>
> ECS wrote:
>> Hi,
>>
>> informix 7.31fc6
>> Using Informix Enterprise Command Center SQL Editor 3.01.TC1
>> I want to query 2 tables, a history table and a planned table.
>> select * from history where date >= ("17/11/2005");
>> select * from planned where date >= ("17/11/2005");
>>
>> Both selects take 5 minutes.
>> The application is continuously running, moving entries from planned to
>> history.
>> How to make sure that I don't miss any entries, or have some doubles?
>>
>> TIA,
>>
>> Daniel
>