Page 2 of 2

Re: Very slow login in Servoy 5.2.2

PostPosted: Tue Dec 07, 2010 7:49 pm
by msedita
Rob, what is the name of problem index and is there any issue with removing it?

Re: Very slow login in Servoy 5.2.2

PostPosted: Tue Dec 07, 2010 9:09 pm
by mboegem
msedita wrote:Question to mboegem - what do you mean by "create a fresh db file"? Do you mean replacing servoy_repository.db with a copy that has no data in any table?


Hi MIchael, that's exactly what I mean.

Re: Very slow login in Servoy 5.2.2

PostPosted: Tue Dec 07, 2010 9:37 pm
by lwjwillemsen
msedita wrote:Rob, what is the name of problem index and is there any issue with removing it?


+1,

Regards,

Re: Very slow login in Servoy 5.2.2

PostPosted: Wed Dec 08, 2010 2:41 am
by Harjo
In our case: the problem occurred because an index ep_rev on servoy_element_properties was interfering with the solution load query.
The index will be dropped as part of Servoy 6 upgrade, as a workaround you can drop it using a db tool: drop index ep_rev

As far as I know, this is for Sybase 11, ONLY!!
be aware, make backups!!

Re: Very slow login in Servoy 5.2.2

PostPosted: Wed Dec 08, 2010 9:52 am
by rgansevles
Be careful, it is always risky to modify stuff directly in the servoy repository.
So make sure to make a backup first.

The index is on servoy_element_properties and can be recreated with:
create index ep_rev on servoy_element_properties (revision)

Rob

Re: Very slow login in Servoy 5.2.2

PostPosted: Wed Dec 08, 2010 5:37 pm
by msedita
Thanks all for your help, removing that index did the trick.