The size of the database does affect the performance of the application, but in theory this should be hardly noticeable. Since all database lookups are done through pre-computed indexes, every tenfold increase in database size should only make lookups about 30% slower. So deleting a few old listing won’t make a huge difference. However, if you have a lot of incoming orders, inserting those into the database might be an issue.
Therefore it would be interesting to know why you experiencing those hangs or freezes. Here is how you can help us find out:
- Launch GarageSale if you don’t have it already running
- Open the Activity Monitor application (under /Application/Utilities)
- Select GarageSale from the list of running applications in Activity Monitor
- Chose “View” menu > “Run Spindump” (Activity Monitor will probably ask you for an admin password at this point)
- Continue using GarageSale normally
- After you experienced a couple of hangs, return to Activity Monitor, save the spin dump log, and send it to me
Every time you see the beachball cursor, what methods GarageSale spends its time in is written to the log file. With that log we can figure out if its indeed the database that slowing GarageSale done, or something else like Thumbnail generation, Category data parsing, inserting new eBay orders or messages into the database.