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
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >