On Thu, 2005-02-03 at 20:43, Edwin A. Epstein, III wrote:

>
>
> Hmmm. Very interesting idea. The DNC_QUE field itself would no longer be
> indexed at all. Then according to your idea a trigger would fire off a UDF
> designed to add it to a seperate que management system that would take care
> of the export, import, and processing of the result files. It would then
> run updates against the database updating the DNC_QUE field back to '0' and
> updating some other fields at the same time.

Exactly.

>
> I don't think it might have to be purchased. Maybe even something like
> MySQL and some PHP that gets triggered every 10 minutes to do the exporting,
> importing, and processing. All I really need is a UDF that can perform an
> insert on a MySQL database.

Why use MySQL? Firebird is easily superior, and minimizing the number
of platform types makes support easier. Having a separate instance of
firebird that you can address from your UDF is all that is required.
Helen might even have some trick of the trade that will allow you how to
do this without a UDF. I know that DB2 and Oracle both have mechanisms
that allow you to talk to other databases from triggers and stored
procedures.

>
> Thanks for the idea! :)

You're welcome.

I think that the indexing improvement that Aage suggested is your least
impact first move - it will buy you time to implement and test this
solution if you choose to do so.

Good luck.