HELP! * GREY=local LOCAL HTML version of Foils prepared July 6,1995

Foil 53 Some Lessons Learned in NPAC's Benchmarking

From Explicit Examples in Parallel Relational Databases CPS600 Spring Semester -- April 1995. by Gang Cheng Marek Podgorny (Geoffrey Fox) * See also color IMAGE

Data partitioning must be very carefully designed to balance I/O and CPU
Parallel Loading is great ! --- almost linear speedup
Backup may be important to save time (we don't have)
The most difficult and trouble-making phase is the database preparation/loading/indexing phase which always involves storage management parameters
you must be both a DBA and sysadm and benchmarking relies critically on system stability
Be prepared to bring down the whole parallel system a couple of times a day
Be prepared that the results are negative (nothing may be obtained !)
you need at least twice the disk space of your original database size
performance tuning is extremely difficult with Oracle 7 parallel server



Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Feb 18 1997