ik skriver:
Queues that are specific for time, like Task Queues that can start for example at 10:00:25 pm but no longer then 10:05:40 pm that day . Let's say you have 5,000 tasks like that on queue. Each of them in different time scale and period. Cron is not the answer. Would you run your task every minute (what if the time to do it is now and you have 30 seconds to do it, you might miss that in cron that works on minutes based) ? would you keep it running as a daemon and collect this data with constantly selecting the proper records ? Would you create a copy of this in RAM to make access it faster, and actually create new table in memory that stores such records twice ? How would you go with that ?It seems to me that what you need is to create a more or less generic scheduler that suits your needs across all your apps and reuse it for all your apps, with appropriate modifications and adaptations if required.
Although you might be working in an environment where such requirements are commonplace, Firebird is used in a vastly wider range of applications, where, for the most part, such scheduling support is not required. So, to enable Firebird to handle that would bloat it with a lot of features that only a small percentage of its users needs. That's a strong indication that "inside Firebird" is not the right place for it.
As others have pointed out, other vendors might support some scheduling features, but not as an integral part of the DB engine, but as an addon app that ships with the engine. Alright, you're free to write such an tool that builds on Firebird and will probably be welcome to advertise it on the Firebird site, at least if it's free and open source. But it is *not* well suited to be integrated inside the engine itself.
I suggest you open your eyes to the world beyond your app domain and see that your requirements are not at all as commonplace as you seem to think.
Kjell
<<attachment: kjell_rilbe.vcf>>
------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
