enough is enough:memory thresh-hold

[ArmenD]

hi all,
plz don't laugh at this ?, it's a serious one on my part.
how/when do i know when a database holds close to or all the memory it can.

in other words, is there some flag that indicates no more tables can be created?

moreover, suppose a db is to contain listing of members. this # grows and i was wondering how to factor rate of growth into this memory calculation?

 

[mrdenny]

What database platform are you using? MySQL, MS SQL, Oracle, Access, FoxPro, etc?

For most databases (MySQL, MS SQL, Oracle, etc) the database can hold as much data as will fit on the hard drives. When the hard drives are full, the database is full.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[alvechurchdata]

Whatever language you're using to insert the latest record should return an error when you try to exceed the storage limit. All you have to do is trap this error. This of course may not be easy.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[ArmenD]

great thanks for quick reply.
when u say trap the error, is this sort of like exception handling?
why would it not be easy?

 

[alvechurchdata]

is this sort of like exception handling

Same sort of thing in different languages - I "raise an error" to deal with an unexpected situation, other people "throw an exception".

why would it not be easy

Because you've said nothing about the database technology you're using. Some make it easy. Some don't.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[ArmenD]

i'll be using mysql server, so do u think the operation mentioned above is easy or not?

 

[alvechurchdata]

i'll be using mysql server

Can't help you there I'm afraid. You might get a better answer in one of the MySQL forums.

Geoff Franklin

http://www.alvechurchdata.co.uk