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

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

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