Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields
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
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" 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
Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields
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" 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
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" 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" 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
I don't think it has anything to do with blobs. You have problem some place else. This looks like to network issue, maybe DNS (wild guess). -- Mgr. Jiří Činčura Independent IT Specialist On Tue, Feb 14, 2017, at 15:35, Federico Paoloni wrote: > 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" 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" 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