maximal model size ?

[moses]

Hi,
did anyone reach a model size that was too big to handle ? Currently we have about 12 000 rows in the t_object table (on MS SQL) and we are about to start two new subprojects. It would be nice to have them all together, but I am sligthly worried about the model size ...
Just now it works fine, only that it takes a while for the whole project to load.
I'll be thankful for any thoughts from others :-)
Moses

[thomaskilian]

I'd guess this is at the limit for .EAP files. But MS SQL should handle much more without problems. Monitor your SQL Server to find out when it's going to be tight.

[Eve]

From memory I got up to around 17 000 in an eap file when importing some test data.  It didn't seem too slow even then, but I wasn't really trying to do a great deal with it.  As Thomas said though MS SQL should handle even larger databases gracefully.

Simon

[moses]

The fear is not about MS SQL not handling the data, it is rather about EA ... things such as project tree loading are simply getting slowier, and the question is whether one day they will be too slow, or rather when will that day come.
I am not sure whether there is other places where the entire or project is beeing read. Or any techniques that would help it load faster ?

thanks :-)

[thomaskilian]

EA is heavily based on database technique. The only slow thing I found so far is a search with Tags included. Also I never really heard of performance problems here in this forum.