HI,

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