Re: Buffer manager

In article <1995Nov13.120705.19760@lulea.trab.se> Krister.Jonsson@sundvall.trab.se writes: >Hello! > >We are trying to model the delays in a database. >To do this we need answers on the following questions. >1. If you have a number of SQL questions, how many percent of the needed > datablocks is it likely that you have to get from the diskstorage?? > >2. Does the answer from question number 1 differ a lot if the ratio > between buffer size and the total amount of data stored > in the database is changed?? Unanswerable. The result depends on what happened before... that is, what is already in the cache. It also depends on how the cache is managed, and how the data is stored on disk, and finally, of course, what the SQL "questions" are and the order in which they are presented. bob -- ********* Wanted: 1968 GTO parts ************* RW Salnick, Spokane,WA | Home: salnick@dejavu.spk.wa.us Amiga 3000, WB 2.1 | Work: salnick@mfgsys.kaiser.spk.wa.us WA9BVE | -----------------