From: Federico P. <fed...@gm...> - 2017-02-13 11:21:23
|
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. |
From: Jiří Č. <ji...@ci...> - 2017-02-14 14:09:53
|
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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Federico P. <fed...@gm...> - 2017-02-14 14:13:39
|
8 second to establish connection Il 14/feb/2017 15:10, "Jiří Činčura" <ji...@ci...> 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 > > Fir...@li... > > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > |
From: Jiří Č. <ji...@ci...> - 2017-02-14 14:16:38
|
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" <ji...@ci...> 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 > > > Fir...@li... > > > 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 > > Fir...@li... > > 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 > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Federico P. <fed...@gm...> - 2017-02-14 14:35:17
|
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" <ji...@ci...> 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" <ji...@ci...> 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 > > > > Fir...@li... > > > > 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 > > > Fir...@li... > > > 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 > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > |
From: Jiří Č. <ji...@ci...> - 2017-02-14 14:38:42
|
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" <ji...@ci...> 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" <ji...@ci...> 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 > > > > > Fir...@li... > > > > > 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 > > > > Fir...@li... > > > > 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 > > > Fir...@li... > > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > > |