Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields

2017-02-14 Thread Jiří Činčura 
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

Re: [Firebird-net-provider] Firebird Net Provider very slow with blob fields

2017-02-14 Thread Federico Paoloni 
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

2017-02-14 Thread Jiří Činčura 
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

2017-02-14 Thread Federico Paoloni 
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

2017-02-14 Thread Jiří Činčura 
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