Hello guys,

Wonder if any of you could help me out here. I have just created an
new empty database and imported data from another database into it.
This was done with the import wizard from MMC.

First thing that I noticed was the size difference, the old database
was well over 1GB, but the new one was only about 400MB.

Second thing I've noticed, and this is the problem, is that accessing
the new (smaller) database instead of the old one causes a huge speed
degradation, about 5 times slower than the old version.

We are using MS SQL Server 7. Any help would be very gratefully
received.

Regards

Gethyn

"Gethyn" <geth@blueyonder.co.uk> wrote in message
news:34b76a2b.0401080147.77d51187@posting.google.c om...
> Hello guys,
>
> Wonder if any of you could help me out here. I have just created an
> new empty database and imported data from another database into it.
> This was done with the import wizard from MMC.
>
> First thing that I noticed was the size difference, the old database
> was well over 1GB, but the new one was only about 400MB.
>
> Second thing I've noticed, and this is the problem, is that accessing
> the new (smaller) database instead of the old one causes a huge speed
> degradation, about 5 times slower than the old version.

One possibility is that indices were not moved over.

Also, the hardware could be different.

Finally, try a UPDATE STATISICS.


>
> We are using MS SQL Server 7. Any help would be very gratefully
> received.
>
> Regards
>
> Gethyn