Membership profile and roles quite slow
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
Is it just me or is retrieving profile/role info for a user incredibly slow? I used some code that creates an ODS for membership, profile and role info and tried to show all users in a grid on a small site with about 110 users and it takes 2m25s to do it. Admittedly that's a local asp.net test server fetching from remote MS SQL DB over my 1Mb/s ADSL, but even when both web and db servers and colocated, it's not much better. Generally, why would I not store most user info in a table of my own making with loweredusername as the key?