January 12, 2004 at 12:52 pm
I have this problem currently that it takes minutes for my database list to come up. I looked at the settings I have and I only have three on.
Auto Update Statisitics
Auto Create Statistics
Torn Page Detection
What should I change then? I am currently trying out the Auto Update Statistics but am concerned that I will lose something for turning this one off.
Thanks,
Deborah
January 12, 2004 at 2:23 pm
Hi, Deborah!
You don't lose any data unsetting the "Auto Update Statistics". The only thing you should note is, if your database has a lot of data modification, that your queries could take much longer.
Test it. There is no problem...
[]s
Giuliano Camarini de Oliveira
Giuliano Camarini de Oliveira
agnitia.com.br
January 12, 2004 at 8:48 pm
Thanks for the response. Speed is definitely an issue though. On further study, I did find two databases that did have Auto Close On. I changed both of them and now my list comes right up! I am new to this website and it is already well worth the time.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply