[Firebird-net-provider] Firebird Net Provider very slow with blob fields
Hi, i have problem with performance of .net firebird net provider. In our company , we have an ERP base on FireBird. One division of my company start to put document inside blob field on ERP an now all my connection with FireBird .net provider is very slow. In my query i don't select the field of the blob. How can i do to have better performance? I must change somenthing in Connection String? Any help would be appreciated. -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields
We just start to insert document inside blob and this behaviour begin. If i make connection with default firebird client connection is immeditly Il 14/feb/2017 15:16, "Jiří Činčura" <j...@cincura.net> ha scritto: > How does that relate to blobs? > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > On Tue, Feb 14, 2017, at 15:13, Federico Paoloni wrote: > > 8 second to establish connection > > > > Il 14/feb/2017 15:10, "Jiří Činčura" <j...@cincura.net> ha scritto: > > > > > What do you mean by slow? Some numbers or something to compare with… > > > > > > -- > > > Mgr. Jiří Činčura > > > Independent IT Specialist > > > > > > > > > On Mon, Feb 13, 2017, at 12:21, Federico Paoloni wrote: > > > > Hi, > > > > i have problem with performance of .net firebird net provider. > > > > In our company , we have an ERP base on FireBird. > > > > > > > > One division of my company start to put document inside blob field > on ERP > > > > an now all my connection with FireBird .net provider is very slow. > > > > > > > > In my query i don't select the field of the blob. > > > > How can i do to have better performance? > > > > I must change somenthing in Connection String? > > > > > > > > Any help would be appreciated. > > > > > > > -- > > > > Check out the vibrant tech community on one of the world's most > > > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > > > ___ > > > > Firebird-net-provider mailing list > > > > Firebird-net-provider@lists.sourceforge.net > > > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > > > > > > > -- > > > Check out the vibrant tech community on one of the world's most > > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > > ___ > > > Firebird-net-provider mailing list > > > Firebird-net-provider@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > > > > > > -- > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > ___ > > Firebird-net-provider mailing list > > Firebird-net-provider@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields
8 second to establish connection Il 14/feb/2017 15:10, "Jiří Činčura" <j...@cincura.net> ha scritto: > What do you mean by slow? Some numbers or something to compare with… > > -- > Mgr. Jiří Činčura > Independent IT Specialist > > > On Mon, Feb 13, 2017, at 12:21, Federico Paoloni wrote: > > Hi, > > i have problem with performance of .net firebird net provider. > > In our company , we have an ERP base on FireBird. > > > > One division of my company start to put document inside blob field on ERP > > an now all my connection with FireBird .net provider is very slow. > > > > In my query i don't select the field of the blob. > > How can i do to have better performance? > > I must change somenthing in Connection String? > > > > Any help would be appreciated. > > > -- > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > > ___ > > Firebird-net-provider mailing list > > Firebird-net-provider@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > -- > Check out the vibrant tech community on one of the world's most > engaging tech sites, SlashDot.org! http://sdm.link/slashdot > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Very slow query with FireBird ado.net provider
Hi jiri, first of all, thanks for your support. I have a problem with firebird ado.net provider. My query is very slow, i think because in database there are some blob field. Is possible to esclude in query string? Thank you so mutch Federico -- -- *Federico Paoloni* *Responsabile Sviluppo* e-Lios S.r.l. Via le Mosse,22 62032 Camerino (MC) Web: http://www.e-lios.eu - E-Mail: federico.paol...@e-lios.eu Il contenuto di predetta comunicazione ed i suoi allegati (se presenti) è strettamente personale e riservata alla persona di cui all’indirizzo. Si raccomanda il rispetto delle norme di cui al D. Lgs. 196/03 e s.m.i. Se avete ricevuto questo messaggio per errore, siete pregati di cancellarlo immediatamente e di informare cortesemente il mittente. La non autorizzata pubblicazione, utilizzazione, diffusione, spedizione, stampa o copia di questo messaggio e dei suoi allegati sono rigorosamente vietati. This e-mail and all attachments (if any) are strictly confidential and intended solely for the use of the individual to whom it is addressed.If you have received this e-mail in error please kindly inform the sender and delete it from your system. Unauthorized publication, use, disclosure, forwarding, printing or copying of this email and its associated attachments are strictly prohibited. -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
