On 4/28/2014 10:29 AM, Carlos H. Cantu wrote: > 3) A way to schedule some tasks direct in FB, for example, > running procures, sweeps, statistics recalcs, etc. at specific > scheduled days/times. What would be accepted as a task could be > limited to whatever you guys thinks that would be "safe" to implement: > http://tracker.firebirdsql.org/browse/CORE-743 > >
I put an internal scheduler in Netfrastructure that would kick off Java procedures using the embedded JVM. It was a big hit, sufficiently big that I ended up with two schedulers, one for system tasks, the other for user tasks, so user tasks didn't block system tasks. The system scheduler tended to get used for garbage collection, etc., and the user scheduler for reports and user mode replication. The user mode replication was interesting. A customer used a single multi-table (Java) trigger to write tables changes into a replication table. When scheduled, the replication task uses a server to server communication facility to broadcast changes from the replication table. If the slave was down, the replication table just got bigger. The resulting system was really slick and worked very well, but it used more than a fair bit more infrastructure than is presently in Firebird. ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available. Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
