Hello,
I've implemeted my own driver based on reflection-drirver to use nhibernate
with Gupta Sqlbase.
Everything is working fine but I discovered bad performance in specific
scenarios.
Simple example:
var Incoices = from incoice in session.Query<Invoice>()
where incoice,Date >= dFrom
select invoice
foreach(Item cItem in Items)
{
double fSum = (from item in session.Query<Items>()
where item.Invoice = cInvoice
select item).Sum();
}
NHibernate do the following:
* Connect to database
* Prepare and execute statement for invoices
* Fetch all Invoices
* Disconnect from database
Foreach item inside foreach:
* Connect to database
* Prepare and execute statement for sum
* Fetch sum
* Disconnect from database
I know MicrosoftSQL is handling this internally and in NHibernate only the
configuration parameter PrepareCommands have to be set.
Gupta SqlBase cannot handle this so a connection has to be opened. For this
connection a IDCommand have to be prepared
and then executed with modified parameter inside of the loop.
Any chance to get this working changing or extending the driver ?
Thanks and best regards
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
