#40 Piggy DB goes to swap file after some time - Piggydb

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

#40 ✓resolved

Piggy DB goes to swap file after some time

Reported by Coooly | January 22nd, 2013 @ 05:17 PM

Hi,

after inactivity Piggy DB seems to go to swapfile (on windows) and when you try to access it again it takes few tens of seconds to wake up.

Is there a way to avoid this behaviour ? Maybe a hidden setting ?

It's a bit frustrating because when's in memory the thing is snappy and in swap is just really slow.

Thanks

Comments and changes to this ticket

marubinotto January 24th, 2013 @ 08:03 AM
Hi Coooly,

Thank you for your report.

That is not expected behavior and I've never experienced such problem. I think it would be a problem with the OS. What's the spec of your PC?

Best regards,
Daisuke
You flagged this item as spam.
Coooly January 24th, 2013 @ 02:28 PM
Hi Marubinotto,

Currently it's a VM (2 cores @ 2.93ghz / 4 Gb / 64 bits) and it's having half of its memory available.

I've seen this also on my workstation which have more of it's 4gb used.

Here's few caps when it's sleeping, waking up and running smoothly.

Seems like it goes there like ten minutes after not being used.
- sleeping.png 3.8 KB
- waking-up.png 11.9 KB
- running.png 5.4 KB
- current-memory.png 11.1 KB
marubinotto February 3rd, 2013 @ 03:33 AM
Sorry for delay in replying.

I think it would be solved if you run Piggydb server as a Windows Service. To do that, you need to install Tomcat in your Windows and deploy Piggydb's War Package to it.
1. Download Tomcat (32-bit/64-bit Windows Service Installer) from http://tomcat.apache.org/download-60.cgi
2. Install Tomcat
3. Download Piggydb War Package (*.war) from http://sourceforge.net/projects/piggydb/files/Piggydb/
4. Copy and rename the war file to C:\Program Files\Apache Software Foundation\Tomcat 6.0\webapps\piggydb.war
5. Start Tomcat service
6. Access to http://localhost:8080/piggydb
You flagged this item as spam.
Coooly March 15th, 2013 @ 09:16 PM
Hello Marubinotto,

So finally had time to done that and ... it works really well. :)

Just a bit strange place where the DB is now stored. (Somewhere beneath system32 folder)

Thank you for your help !
marubinotto March 16th, 2013 @ 04:12 AM
- State changed from “new” to “resolved”
You are welcome!

Just a bit strange place where the DB is now stored.

I guess that is because the user of a windows service is not your account. You can change the database location:

http://piggydb.jp/en/fragment.htm?id=16

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.