psujeeperman02
New Member
Hi, I came into my current position about 2 years ago when the original Syteline administrator left the company. Since then, and due to my very little knowledge of the Syteline app and its DB, we have not done any db maintenance to Syteline.
I hear about doing a reindexing of the DB, and possibly a dump and load. I am a weary on doing the dump and load as i have no experience with this and i hear it can cause lots of problems.
So, onto the indexing of the db. what does this include? how long will it usually take to run? have any of you run into problems by simply doing a reindex of the database? What should i look out for?
Our database is just pushing 4.5 Gbs and has been over two years since the last index has been run.
Any info will be greatly appreciated.
I hear about doing a reindexing of the DB, and possibly a dump and load. I am a weary on doing the dump and load as i have no experience with this and i hear it can cause lots of problems.
So, onto the indexing of the db. what does this include? how long will it usually take to run? have any of you run into problems by simply doing a reindex of the database? What should i look out for?
Our database is just pushing 4.5 Gbs and has been over two years since the last index has been run.
Any info will be greatly appreciated.