Andrew,

Thanks for the info. That was something I was loooking for down the road.

However, for my test app returning 35 records in less than 2 seconds
with NO Blobs and 32 seconds with blobs conataing a total 3,209 plain
text characters does not make sense?? Especially, when all get
returned very fast on a local connection.

Does anyone have any ideas??

Thanks,

Austin



--- In firebird-support@yahoogroups.com, "andrew_s_vaz"
<andrew_s_vaz@b...> wrote:

>
> Hi,
>
> Have you tested this connection with somehting like Zebedee?
> It does compress the data, so it must give you some speed gain over
> slow lines.
>
> ZeBeDee home:
> http://www.winton.org.uk/zebedee/
>
> Info on how to use zebedee with Firebird:
>

http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1105496344:633417&page=ibp_zebedee

>
>
> HTH
> Andrew
>
> > I'm using both Delphi7 with update 1 and D2005 with updare 2. Both
> > give the same results.
> >
> > I am using dbExpress with the Borland Interbase driver, and I also
> > tested with Upscene's Firebird dbExpress driver. Same performance.
> >
> > I also tested with D7's ADO using Firebird's ODBC. Better results, but
> > still very slow.
> >
> > I also tested with Borland's native Interbase components, and FIBPlus
> > and both are still very slow.
> >
> > My query is simply:
> >
> > sql:='select * from pPMMasterTask where procedureNumber = 13'
> >
> > or with out the Blob field
> >
> > sql2:='select ProcedureNumber, TaskNumber, CraftCode, MPSetNumber,
> > Signature, UserID, LastUpdated from pPMMasterTask where
> > procedureNumber = 13'
> >
> > Yhe table is defined below.
> >
> > This is a strange problem to me. Performance can not be this slow, it
> > must be some network or Firebird config or comatability problem??
> >
> > Thanks for the help,
> >
> > Austin
> >
> >
> >
>

/******************************************************************************/

> > /**** Generated by IBExpert 4/10/2005 12:02:43 PM
> > ****/
> >
>

/******************************************************************************/

> >
> > SET SQL DIALECT 3;
> >
> > SET NAMES NONE;
> >
> >
> >
> >
>

/******************************************************************************/

> > /**** Tables
> > ****/
> >
>

/******************************************************************************/

> >
> >
> >
> > CREATE TABLE PPMMASTERTASK (
> > PROCEDURENUMBER INTEGER NOT NULL,
> > TASKNUMBER INTEGER NOT NULL,
> > TASKDESCRIPTION BLOB SUB_TYPE 1 SEGMENT SIZE 80,
> > CRAFTCODE CHAR(2),
> > MPSETNUMBER INTEGER,
> > SIGNATURE VARCHAR(30),
> > USERID VARCHAR(12),
> > LASTUPDATED TIMESTAMP
> > );
> >
> >
> >
> >
> >
>

/******************************************************************************/

> > /**** Primary Keys
> > ****/
> >
>

/******************************************************************************/

> >
> > ALTER TABLE PPMMASTERTASK ADD CONSTRAINT PK_PPMMASTERTASK PRIMARY KEY
> > (PROCEDURENUMBER, TASKNUMBER);
> >
> >
> >
>

/******************************************************************************/

> > /**** Indices
> > ****/
> >
>

/******************************************************************************/

> >
> > CREATE INDEX PPMTASKCC ON PPMMASTERTASK (CRAFTCODE);
> > CREATE INDEX PPMTASKID ON PPMMASTERTASK (USERID);
> > CREATE INDEX PPMTASKMPOINTSET ON PPMMASTERTASK (MPSETNUMBER);
> >
> >
> >
> > --- In firebird-support@yahoogroups.com, "Svend Meyland Nicolaisen"
> > <news@s...> wrote:
> > > What are you using to access the database?
> > >
> > > What does the metadata of the tables look like?
> > >
> > > What does the used queries look like?
> > >
> > > /smn
> > >
> > > > -----Original Message-----
> > > > From: ggroper [mailto:ggroper@y...]
> > > > Sent: 9. april 2005 19:30
> > > > To: firebird-support@yahoogroups.com
> > > > Subject: [firebird-support] Performance Problem with BOLBs??
> > > >
> > > >
> > > >
> > > > Hi,
> > > >
> > > > Ai I mention above I'm trying to determine a performance
> > > > problem with a simple quety returning data from a single
> > > > table. The problem appears to be related to Blob fields.
> > > >
> > > > My query returns 35 records out of 66,000 based on a simple
> > > > select * from table where field 1 = 13, field 1 being indexed
> > > > , or a query with the fields specified with out the Blob field.
> > > >
> > > > My times to poulate a grid in a D7 program are as follows:
> > > > Local Database - No Memos=0.24 seconds
> > > > With Memos=0.47 seconds
> > > >
> > > > Remote Database - No Memos=1.54 seconds
> > > > With Memos=31.75 seconds
> > > >
> > > > Why is there a 30 second performace penality when going to a
> > > > remote database??
> > > >
> > > > I thought the database may be corrupted, so I did a local
> > > > back up and restore and sent the new database to the remote
> > > > host this morning and get the same results. The total amount
> > > > of data in the 35 memo fields is very small and all plain text.
> > > >
> > > > Is this performance with Blob fields normal for Firebird or
> > > > could there be some Firebird config problem. The host claims
> > > > to be using FB
> > > > 1.52 and so am I. If they are using an earlier version could
> > > > this cause a problem.
> > > >
> > > > Any ideas,
> > > >
> > > > Austin
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >