On Tue, Aug 2, 2011 at 11:46, korkless <[email protected]> wrote:
> i have a service which use a dbdataadapter every minute to insert data into
> a single table (the istance is recreate every time becouse i need thread
> safety), i see that it calls every time the method
> FbDataReader.GetSchemaTable to get the schema from the db with a single
> query for every column of the table.
> is it possible to get the table schema only once and then set it every time
> so the dataadapter doesn't need to recreate it?
Why don't you use plain FbCommand to insert data? Anyway from top of
my head I don't know. But you can, for sure, create the thread safe
instances and use these, I think it would be simpler.
> i have also an unrelated suggestion, i see that FbCommand.CommandTimeout is
> not used, it's better to tell it into the property documentation so people
> know suddently it and don't spend 1 hours to discover it :)
It's not used, because FB directly doesn't support it, but it might
work with new cancellation support in FB2.5. Hard to say whether it's
worth implementing.
--
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com
------------------------------------------------------------------------------
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
