[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

Title:	FOCUS, from INFORMATION BUILDERS

Moderator:	ZAYIUS::BROUILLETTE

Created:	Thu Feb 19 1987
Last Modified:	Mon May 05 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	615
Total number of notes:	1779

273.0. "Focus/RDB performance problems" by BTOVT::STODDARD_N () Mon Oct 09 1989 12:36

    We're in the process of implementing a Focus/RDB Data Access
    environment and are finding performance extremely slow.  A Focus 
    procedure that used to take 5 seconds against Focus files now
    takes 45 seconds against RDB.  The same procedure takes 5 seconds
    using RDB or SQL.  The problem appears to be Focus against RDB.
    Does anyone have any suggestions for us.
    
    Nancy Stoddard (266-4425)

T.R Title User Personal
Name Date Lines

273.1 What about Datatrieve ? GVAADG::PERINO Joel PERINO @GEO Tue Oct 10 1989 08:06 17

273.2 Improved Performance Date fields ILO::BROCKLEBANK Thu Dec 21 1989 12:44 18

T.R	Title	User	Personal Name	Date	Lines
273.1	What about Datatrieve ?	GVAADG::PERINO	Joel PERINO @GEO	`Tue Oct 10 1989 08:06`	17
273.2	Improved Performance Date fields	ILO::BROCKLEBANK		`Thu Dec 21 1989 12:44`	18
	One problem 5.2 has is with RdB date fields. It can't read them directly and thus causes severe performance problems if your Fex is accessing these date fields. I believe version 5.5.1 & 5.2.2 of Focus can access RdB dates properly. This not only makes it easier to set up master files, but also improves performance. These versions can also use the RdB index on a date field. The .mas syntax is as follows FIELDNAME=DATE ,ALIAS=DATE ,YMD ,DATE ,$ the .acx FIELD=DATE,TYPE=ADT,$ Regards, Dave

One problem 5.2 has is with RdB date fields.  It can't read them directly
and thus causes severe performance problems if your Fex is accessing
these date fields.

I believe version 5.5.1 & 5.2.2 of Focus can access RdB dates properly.
This not only makes it easier to set up master files, but also improves
performance.  These versions can also use the RdB index on a date field.

The .mas syntax is as follows

      FIELDNAME=DATE          ,ALIAS=DATE          ,YMD     ,DATE       ,$

the .acx

     FIELD=DATE,TYPE=ADT,$

Regards,
Dave