database overflow - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

database overflow

database overflow# Database - 数据库

m*r2004-03-15 08:03

1 楼

hea, there, I am not majoring in database but encounter some problems related.
Hope to ask and receive some feedback. Thanks.
Suppose that a database can accormodate N records. Now, when the database is
full and a new record is coming. Then, how to add this new record into the
database.
I know one scheme. Firstly, delete the old record with the longest time
duration in the database. And then, add the new record into the database.
1. I wonder whether there are other schemes to deal with such cond

aw2004-03-15 08:03

2 楼

can't understand why you need to do this. you can always enlarge the data file
size, add more disks, backup to tape, etc., for more space.
deleting record without backup is always bad idea.

related.

【在 m*****r 的大作中提到】

: hea, there, I am not majoring in database but encounter some problems related.
: Hope to ask and receive some feedback. Thanks.
: Suppose that a database can accormodate N records. Now, when the database is
: full and a new record is coming. Then, how to add this new record into the
: database.
: I know one scheme. Firstly, delete the old record with the longest time
: duration in the database. And then, add the new record into the database.
: 1. I wonder whether there are other schemes to deal with such cond