Page 1 of 1

SQL Complete Member List and big databases

Posted: Tue 21 Dec 2010 10:40
by Yegoroff
Hello,

We have a huge database containing approx 1000 tables and 1500 of other object types.
SQL Complete objects describe longs for a several minutes, that is not a reasonable time to provide smooth user experience. As a comparison I've test the SQL Assistant which do this in a several seconds.
Right now intellisense functionality is unavailable for the most of my queries, it would be great if you optimize SQL Complete performance to a reasonable times.

Posted: Thu 23 Dec 2010 12:45
by .jp
Thanks for the post.
We will prepare a separate server to emulate your situation.
Can you please specify the following:
1) the speed of the connection with the remote server
2) what are the timings of connection delays
3) average server loading