| Title: | DEC Rdb against the World |
| Moderator: | HERON::GODFRIND |
| Created: | Fri Jun 12 1987 |
| Last Modified: | Thu Feb 23 1995 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1348 |
| Total number of notes: | 5438 |
I have a customer using INGRES on a 8820 and he is experiencing a
problem with is night jobs. They are batch jobs and they can't
seem to get to use more than 50 % of the CPU. We analysed the
ressources usage and found no real bottleneck that can explain
the observed behavior. We suspect the application and/or Ingres
but we can't proove it. I've been told that Ingres has problem with
heavy loads, and that incorporating RDB in the picture would help.
I need someone who's been through such problem that could guide
me through that.
Gaetan
DTN 632-7884
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 333.1 | There are load problems | TAV02::ARIE_L | Arie Levy | Tue Apr 18 1989 16:12 | 26 |
> problem with is night jobs. They are batch jobs and they can't > seem to get to use more than 50 % of the CPU. What do you meen by "batch job". is it 3gl with embedded sql, ABF/osl, or some utility. > ressources usage and found no real bottleneck that can explain > the observed behavior. We suspect the application and/or Ingres > but we can't proove it. Was I/O a bottleneck. > I've been told that Ingres has problem with > heavy loads, and that incorporating RDB in the picture would help. > I need someone who's been through such problem that could guide > me through that. It is true that loading a table with 3GL program is problematic sience INGRES is doing at least 1, usually more I/Os per record, even if you commits every N'th record. The preffered way to load into INGRES is to use "copy" utility. Hope it helps Arie Levy | |||||