Firebird Net Provider very slow with blob fields

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Firebird Net Provider very slow with blob fields

Federico Paoloni-2
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Firebird Net Provider very slow with blob fields

Jiří Činčura-2
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
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Firebird Net Provider very slow with blob fields

Federico Paoloni-2
8 second to establish connection

Il 14/feb/2017 15:10, "Jiří Činčura" <[hidden email]> 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


------------------------------------------------------------------------------
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
[hidden email]
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Firebird Net Provider very slow with blob fields

Jiří Činčura-2
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" <[hidden email]> 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
> > > 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
> > 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
> 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Firebird Net Provider very slow with blob fields

Federico Paoloni-2
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" <[hidden email]> 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" <[hidden email]> 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
> >
> >
> > ------------------------------------------------------------
> > ------------------
> > 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
> >
> >
> ------------------------------------------------------------------------------
> 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


------------------------------------------------------------------------------
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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Firebird Net Provider very slow with blob fields

Jiří Činčura-2
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" <[hidden email]> 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" <[hidden email]> 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
> > > > > [hidden email]
> > > > > 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
> > > > 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
> > > 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
[hidden email]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Loading...