Multiqueries needed to improve performance !
--------------------------------------------
Key: CORE-3592
URL: http://tracker.firebirdsql.org/browse/CORE-3592
Project: Firebird Core
Issue Type: Improvement
Affects Versions: 2.5.0
Reporter: Przemyslaw Jenarzewski
Priority: Critical
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 ... ;"
or
"update a set...; update b set..."
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Special Offer -- Download ArcSight Logger for FREE!
Finally, a world-class log management solution at an even better
price-free! And you'll get a free "Love Thy Logs" t-shirt when you
download Logger. Secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsisghtdev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
