Please implement multiqueries support for firebird,
so insert/update/select queries could be send as one sql and results will be delivered as one dataset.
It is very important feature to speed up database access (also for bigger applications).
Some other database providers (MS Sql Server,MySQL,PostGreSQL,SQLite,Microsoft SQL CE) are already using this.
We would able to use some optimisations ie with NHibernate and other cases.
Some performance boost ca 25-30% could be done through this feature (see: http://ayende.com/blog/3979/nhibernate-futures)
"select * from a;
select * from b;" could be send as single sql
With inserts/Updates is the same problem, they are send to DB as single sql which is slow. Again, we could send single sql:
"insert into a ....;insert into b ... ;"
"update a set...; update b set..."