Very slow login in Servoy 5.2.2

Questions, answers, tips and ideas on Servoy Client

Re: Very slow login in Servoy 5.2.2

Postby msedita » Tue Dec 07, 2010 7:49 pm

Rob, what is the name of problem index and is there any issue with removing it?
Michael Sedita
MS Health Software Corp.
Developers of software solutions for behavioral healthcare and social service providers.
www.mshealth.com
User avatar
msedita
 
Posts: 224
Joined: Thu Dec 13, 2007 8:01 pm

Re: Very slow login in Servoy 5.2.2

Postby mboegem » Tue Dec 07, 2010 9:09 pm

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.
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1742
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Very slow login in Servoy 5.2.2

Postby lwjwillemsen » Tue Dec 07, 2010 9:37 pm

msedita wrote:Rob, what is the name of problem index and is there any issue with removing it?


+1,

Regards,
Lambert Willemsen
Vision Development BV
lwjwillemsen
 
Posts: 680
Joined: Sat Mar 14, 2009 5:39 pm
Location: The Netherlands

Re: Very slow login in Servoy 5.2.2

Postby Harjo » Wed Dec 08, 2010 2:41 am

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!!
Harjo Kompagnie
ServoyCamp
Servoy Certified Developer
Servoy Valued Professional
SAN Developer
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Re: Very slow login in Servoy 5.2.2

Postby rgansevles » Wed Dec 08, 2010 9:52 am

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
Rob Gansevles
Servoy
User avatar
rgansevles
 
Posts: 1927
Joined: Wed Nov 15, 2006 6:17 pm
Location: Amersfoort, NL

Re: Very slow login in Servoy 5.2.2

Postby msedita » Wed Dec 08, 2010 5:37 pm

Thanks all for your help, removing that index did the trick.
Michael Sedita
MS Health Software Corp.
Developers of software solutions for behavioral healthcare and social service providers.
www.mshealth.com
User avatar
msedita
 
Posts: 224
Joined: Thu Dec 13, 2007 8:01 pm

Previous

Return to Servoy Client

Who is online

Users browsing this forum: No registered users and 9 guests