I dont have much knowledge about external tables, let me study them and will get back if i have any doubts.

But, i would like to say that the raw data should be created and populated by us...i hope this should be possible in external tables.?

thanking you
Abhishek Sharma

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 06:00 PM 23/12/2009, you wrote:
>
> >Hi,
> >
> >We have an application which takes some raw data as input, processes it and stores the output in different tables.
> >Now i dont want my raw data to be the part of the backup, as over a period of time the raw data will increase.
> >
> >Also, i dont want to delete the raw data from my original database, unless the user explicitly asks to delete the data.
> >
> >I thought of keeping the data in a seperate db initially, but later thought certain queries may take long time to execute.
>
> Well - either
> / you want the raw data in the database (because you have to return to it for some reason) and therefore it should be backed up
> or
> /you are not interested in the raw data once it has been extracted into tables
>
> Are you using external tables for the raw input?
>
> ./heLen
>