kevind
Active Member
   

I was more than willing to "pony up", how b'out U?
Posts: 634
Gender:
|
No, you do not need to do any datafile rebuilds on a regular basis. You should only do them to solve a problem with an index, or to reduce the size of a datafile that has had many records deleted from it. For example, if you archive Work orders, or PO's, you can rebuild the appropriate files so that the deleted space from the data file is removed. Data files grow as needed, but do not shrink if records are deleted. By rebuilding, you are copying only the data records to a new file; not the deleted space. If you have plenty of hard drive space, it does not mater if you shrink these files. Pervasive uses it's own page allocation scheme internal to the data files. If you don't shrink them, then pervasive does not have to expand the file to add new records; it just uses the already allocated ( unused ) space.
|