| 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 |
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 05:06 | 17 |
We experienced the same performance problem with FOCUS/Rdb in
AMIS. AMIS produces short list or graph after the user has given
few simple parameters using a user-friendly interface.
When we changed the file structure from RMS files to Rdb in
FEB-88 I did a test of performance and it was quite comparable.
Since Rdb 3.0 has been installed the performance has dropped from
10/15 seconds to 35/40 for an average report. We suspect FOCUS is
not coping very well with this new Rdb version.
Because AMIS is a reporting tool for executive (EIS) the response
time is a key factor so we redesigned the application using DTR/Rdb
for list and graphics. The response time is now from 3 to 5 seconds
for whatever kind of query.
Jo�l
| |||||
| 273.2 | Improved Performance Date fields | ILO::BROCKLEBANK | Thu Dec 21 1989 09: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
| |||||