Optimized I/O buffers having the ability to increase or decrease in size to meet system requirements

A method of optimizing the size of first and second I/O buffers of a computer system when inserting data into a database, said first and said second I/O buffers residing in main storage, said method comprising the steps of:

• determining if said second buffer is full before said computer system has completely written the contents of said first buffer to said database, said determining step being performed by said computer system;
• increasing the size of said first and second buffers if said second buffer is full before said computer system has completely written the contents of said first buffer to said database, said increasing step being performed by said computer system;
• determining if said computer system has completely written the contents of said first buffer to said data base before said computer system has filled said second buffer beyond a threshold percentage, said determining step being performed by said computer system;
• and
• decreasing the size of said first and second buffers if said computer system has completely written the contents of said first buffer to said data base before said computer system has filled said second buffer beyond said threshold percentage, said decreasing step being performed by said computer system.

A method of optimizing the size of first and second I/O buffers of a computer system when retrieving data from a database, said first and second buffer residing in main storage, said method comprising the steps of:

• determining if said computer system has emptied said first buffer before said computer system has completely read the contents of said second buffer from said database, said determining step being performed by said computer system;
• increasing the size of said first and second buffers if said computer system has emptied said first buffer before said computer system has completely read the contents of said second buffer from said database, said increasing step being performed by said computer system;
• determining if said computer system has completely read the contents of said second buffer from said database before said computer system has emptied said first buffer below a threshold value, said decreasing step being performed by said computer system;
• and
• decreasing the size of said first and second buffers if said computer system has completely read the contents of said second buffer from said database before said computer system has emptied said first buffer below said threshold value, said determining step being performed by computer system.

A computer system having optimized first and second I/O buffers for inserting data into a database, comprising:

• a main storage having said first and second buffers;
• an auxiliary storage having said database;
• means connected to said main storage for determining whether said second buffer is full before the contents of said first buffer are completely written to said database;
• means connected to said main storage for increasing the size of said first and second buffers if said second buffer is full before the contents of said first buffer are completely written to said database;
• means connected to said main storage for determining if the contents of said first buffer have been completely written to said database before said second buffer is filled beyond a threshold value;
• and
• means connected to said main storage for decreasing the size of said first and second buffers if the contents of said first buffer have been completely written to said database before said second buffer is filled beyond said threshold value.

A computer system having optimized first and second I/O buffers for retrieving data from a database, comprising:

• a main storage having said first and second buffers;
• an auxiliary storage having said database;
• means connected to said main storage for determining whether said first buffer is emptied before the contents of said second buffer have been completely read from said database;
• means connected to said main storage for increasing the size of said first and second buffers if said first buffer is emptied before the contents of said second buffer have been completely read from said database;
• means connected to said main storage for determining if the contents of said second buffer are completely read from said database before said first buffer is emptied below a threshold value;
• and
• means connected to said main storage for decreasing the size of said first and second buffers if the contents of said second buffer are completely read from said database before said first buffer is emptied below said threshold value.

A computer system having optimized first and second I/O buffers, comprising:

• a main storage having said first and second buffers;
• an auxiliary storage;
• means connected to said main storage for determining if said second buffer is fully processed before the contents of said first buffer have been completely written to said auxiliary storage;
• means connected to said main storage for increasing the size of said first and second buffers if said second buffer is fully processed before the contents of said first buffer have been completely written to said auxiliary storage;
• and
• means connected to said main storage for determining if the contents of said first buffer have been completely written to said auxiliary storage before said second buffer triggers a threshold percentage;
• and
• means connected to said main storage for decreasing the size of said first and second buffers if the contents of said first buffer have been completely written to said auxiliary storage before said second buffer triggers said threshold percentage.

A computer system having optimized first and second I/O buffers, comprising:

• a main storage having said first and second buffers;
• an auxiliary storage;
• means for determining if said first buffer is emptied before the contents of said second buffer have been completely read from said auxiliary storage;
• means for increasing the size of said first and second buffers if said first buffer is emptied before the contents of said second buffer have been completely read from said auxiliary storage;
• means connected to said main storage for determining if the contents of said second buffer have been completely read from said auxiliary storage before said first buffer is emptied below a threshold value;
• and
• means connected to said main storage for decreasing the size of said first and second buffers if the contents of said second buffer have been completely read from said auxiliary storage before said first buffer is emptied below said threshold value.