I have been having strange crashes while using my database. I read here that sometimes importing all objects into new blank database will help with some problems, so tried it for kicks (yeah I know, get a life huh). When I did, and then started to compile, it found numberous errors in code that it never found before. But biggest diff was the new database is about 80% smaller, but seems to run much slower.
Any ideas ? Is this normal to shrink this much ? Why should it run slower ?
It might be that various indices got dropped or rebuilt when you migrated the rest of the objects. Indices are usually the objects to bloat the fastest and take up more space than you would believe possible!