Enhance performance of expanding a database.
One of the systems I work on is Microsoft Great Plains, it has over 30,000 stored procedures and expanding the database to start a query takes a very long time (minutes).
4
votes
anonymous
shared this idea
The performance with large schemas has improved considerably from V2.0, so you might find it’s OK now. If not, you can uncheck ‘Include SPs and Functions’ in the connection info to prevent LP from loading the stored procs.