Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Compact Derby Database  XML
Forum Index » SysAid Installation & Beyond
 
Author Message
[Post New]27/08/2010 09:24:23
    Subject: Compact Derby Database
[Up]
SwRI15
SysAider

SysAider from release 4.5 United States
Joined: 16/11/2009
Messages: 13
Offline
SysAid's really been slowing down lately. The OS is running fine. Is there a way to compact the database or something to speed it up?
Thanks!
[Post New]29/08/2010 03:06:34
    Subject: Compact Derby Database
[Up]
itayH
SysAid Customer Relations


Joined: 23/09/2009
Messages: 1092
Offline
Hi SwRI15,

Currently Derby doesn't support shrinking like SQL does.
What is your ...\SysAidServer\root\WEB-INF\db folder size?
Which version\edition are you using?

This message was edited 1 time. Last update was at 29/08/2010 03:06:59
Best Regards,
Itay
[Post New]31/08/2010 10:45:46
    Subject: Re:Compact Derby Database
[Up]
SwRI15
SysAider

SysAider from release 4.5 United States
Joined: 16/11/2009
Messages: 13
Offline
The db folder is 1.14GB and we're running v7.0.05
[Post New]01/09/2010 07:00:41
    Subject: Compact Derby Database
[Up]
itayH
SysAid Customer Relations


Joined: 23/09/2009
Messages: 1092
Offline
Hi SwRI15,

Would you consider migrating your DB to SQL?

In any case, please send us email to helpdesk@sysaid.com or open a SR in http://helpdesk.ilient.com regarding this issue with short description, link to the post and the support team will contact you.
Best Regards,
Itay
[Post New]01/09/2010 08:51:05
    Subject: Re:Compact Derby Database
[Up]
SwRI15
SysAider

SysAider from release 4.5 United States
Joined: 16/11/2009
Messages: 13
Offline
No, I don't think we'd have a problem with that. Is there a step-by-step procedure available?
Forum Index » SysAid Installation & Beyond
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
    SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Skype account:ilient
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011 		   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   02:00 AM - 04:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use