Page 2 of 2
Re: Very slow login in Servoy 5.2.2
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
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
Posted:
Wed Dec 08, 2010 5:37 pm
by msedita
Thanks all for your help, removing that index did the trick.