Phil
As stated elsewhere the data would be immediately available via a Union
Query, though i'd be wary of using a union view
ie
create view AllData as
select * from MainTable
union
select * from TempTable
as I think your queries would thow a hissy fit!, As I would predict that
selection criteria would be applied after the union and not before
ie
select * from alldata where col1 = val1
<>
select * from MainTable where col1 = val1
union
select * from TempTable where col1 = val1
You could of course use use stored procs. You could also investigate some of
the recent data mining
functions of some of the SQL databases (I'm not sure about oracle) but some
of them have 'instead of' triggers
(MSSQL & postgreSQL) where you can override the actions of 'select' (a
select trigger). This way you
could make the select union when there is data in the log and main otherwise
select on the main table.
Bear in mind I might be completely wrong as I'm not sure if you can get
access to the raw text of the
query (which you would need) and I know that MS SQL has 'instead of' on
inserts but not if it supports selects
HTH (or is at least a bit interesting)
Neven
----- Original Message -----
From: "Phil Scadden" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Tuesday, 17 July 2001 09:22
Subject: Re: [DUG]: Single MASSIVE table. Recommendations?
> > Have you considered bulk loading the new data into a temp table and then
> > merging it into the main database - overall the load would be slower
> > (indices being updated constantly) but the database would be continually
available (you
> > could use a server side process to merge)
>
> Worth considering. The total time taken for load though would still be
long. It becomes
> a problem when want to use the new data very soon after arrival. Otherwise
> the availability issue isnt a problem.
>
> Thanks
>
> ----------------------------------------------------------
> Phil Scadden, Institute of Geological and Nuclear Sciences
> 41 Bell Rd South, PO Box 30368, Lower Hutt, New Zealand
> Ph +64 4 5704821, fax +64 4 5704603
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
