Re: [Firebird-net-provider] RoleProvider

2006-11-08 Thread Le roy Arnaud
Steve Ramacher a utilisé son clavier pour écrire : >> Nothing I want said fbmembership provider.cs. i have correct some bug : >> 1) when you create an user IsOnline is not set so a exception is raised > >> because the domain's bool is NOT NULL. > Hello in the cvs i have put your changes but i have

Re: [Firebird-net-provider] RoleProvider

2006-11-08 Thread Steve Ramacher
>Nothing I want said fbmembership provider.cs. i have correct some bug : >1) when you create an user IsOnline is not set so a exception is raised >because the domain's bool is NOT NULL. I have a script that was corrected and forwarded to Le roy Arnaud about 3 weeks ago that correct these concerns

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Jiri Cincura
Le roy Arnaud wrote: > Nothing i want said fbmembership provider.cs. i have correct some bug : :P -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to su

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Le roy Arnaud
> Well, with 8k page size, the table roles is OK... But I think the 4k page > size we should handle as base. But changing the implementation isn't good. > Maybe we should way, if somebody will report this as a problem and then make > final decision. OK? > Ok. > What's wrong with membership pro

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Jiri Cincura
Le roy Arnaud wrote: > I have look to add primary key on each table but there is a problem > with the role and usersrole tables because this table have not column > that accept primary key because their size is too big so i must change > the struct of these tables and change the role provider !

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Le roy Arnaud
>> yes, in fact they must be an index on each provider's table > > OK, nice. Will you commit new sql script? > I have look to add primary key on each table but there is a problem with the role and usersrole tables because this table have not column that accept primary key because their size is to

Re: [Firebird-net-provider] RoleProvider index

2006-11-08 Thread Le roy Arnaud
Jiri Cincura a couché sur son écran : > Le roy Arnaud wrote: >> it could be a good idea but for exemple in the membership provider >> delete function have a parameter ("deleteAllRelatedData") that define >> if all related data of the users should be delete and if we put an fk >> the related dat

Re: [Firebird-net-provider] RoleProvider index

2006-11-07 Thread Jiri Cincura
Le roy Arnaud wrote: > it could be a good idea but for exemple in the membership provider > delete function have a parameter ("deleteAllRelatedData") that define > if all related data of the users should be delete and if we put an fk > the related data will be always delete. :\ > An other pro

Re: [Firebird-net-provider] RoleProvider index

2006-11-07 Thread Le roy Arnaud
> OK, nice. Will you commit new sql script? Ok i will commit this changes tomorrow > BTW what about adding (optional) FK constraint to be able to delete users > from console without havving any stub in database. What do you think? it could be a good idea but for exemple in the membership provide

Re: [Firebird-net-provider] RoleProvider index

2006-11-07 Thread Jiri Cincura
Le roy Arnaud wrote: > Jiri Cincura a émis l'idée suivante : >> Just small note, what about adding PK into RoleProvider's table? With a lot >> of users/roles this can be a bottleneck without index. > > yes, in fact they must be an index on each provider's table OK, nice. Will you commit new sql

Re: [Firebird-net-provider] RoleProvider index (was: FbProfileProvider)

2006-11-07 Thread Le roy Arnaud
Jiri Cincura a émis l'idée suivante : > Just small note, what about adding PK into RoleProvider's table? With a lot > of users/roles this can be a bottleneck without index. yes, in fact they must be an index on each provider's table -

[Firebird-net-provider] RoleProvider index (was: FbProfileProvider)

2006-11-07 Thread Jiri Cincura
Just small note, what about adding PK into RoleProvider's table? With a lot of users/roles this can be a bottleneck without index. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomc