Hi, Env: TDK 2.3/Flux, MySQL 4/Oracle, JDK 1.4.1
In the system I am building I need to have data dependent security, ie security access to particular fields etc depends on the the application data in the fields. I'm using Flux to do this. To accomplish this I am creating a group per Item that the applicationd deals with and assigning users that require access to that item into the group. While I haven't measured yet I am worried about the performance of this approach. here are the numbers: #roles: 7 #permissions: 50 #groups: 2500 growing by about 1000 per year #users: 1000 Now in the debug log I see a large number of seemingly identifcal repetitive SQL calls. And there are now sizeable delays when logging in and generating screeens etc. Has anyone implemented turbine with these orer of numbers , if so, were there any tricks , tips, mods that you used to improve performance? Any thoughts or suggestions would be appreciated. Thanks Peter
