Simple Invoices - Forum

To be fair the project is less than 1 year old and the code was released to the community only few months ago. (2 or 3 months).
Anyway, the biggest problems of simpleinvoice are 2 at the moment.
- It's not reactive enough -
- uses way too much resources on the server -
Solved the above flaws it's a nicer and probably more user friendly invoice system

Ok,
Would it be possible to migrate existing customers & invoices to myclientbase or will we need to start from scratch again? (I guess yes...)
Maybe customers can be sql'd over to the myclientbase database, but I guess there it ends, right? Any hints?

what is the lastest on this. I have 400 customers and 400 products so far, 1000 invoices a year, average 2-5 items per invoice, Will I encounter this slowdown issue simiply using the window download version? I am just a newbie and dummie.

We are still in same condition. It is still a loading problem in simple invoices.

Or is there any solution in these topics?

I've just come back to the forums so as to give SI one last chance. I've installed myclientbase and migrated all my clients across. It isn't as nice a piece of software (although it has some nice touches - being able to generate a client on-the-fly is useful in my application), but it is so much faster!

On my set-up, I have 805 clients, 1026 invoices, and 91 products. The main Invoices page takes nearly 4 minutes to show up. I've already had to move it off my main webserver box, because it was killing webpage serving performance, so now I can't use it from 'anywhere' but only 'somewhere'. I've had to increase the timeout in php.ini to stop the whole thing from timing-out!

It is a huge shame. When I first used SI it was fantastic, such a breath of fresh air. But, as things have loaded-up, it has ground to a halt.

The code is, as has been mentioned, frighteningly inefficient. The performance is such that we've been putting-off generating invoices and (especially) receipts for customers just to avoid wasting time on it, which is such a shame. I've given-up logging customer payments on the system (too time-consuming), which means that the data is getting horribly out-of-date, and is being augmented by an Excel spreadsheet to keep track of what has been paid. That's not good.

And, yes, I've tried the indexes. It hasn't helped very much.

As I say, it is a huge shame; the software is great, easy to use, easy to understand, easy to explain, but, with not very many records in the grand scheme of things, completely unusable.

I shall keep checking-in here to see if anything has changed, because I'd love to go back to it some day.

Hi skwdenyer,

I'm working right now in cleaning up code for SI as I want to use it myself. Although I've already trapped some missing indexes it would be great if you could guide me by telling me where you find slow responses in order to double check.

I hope in a near future the changes will get released but there is still some work to do.

If you would like to contribute it would be great if you could test the unstable version at the trunk with your data and see see if it improves performance. It would be great to have someone with so much data reporting errors and slow performance issues. Just keep it updated as I'm changing it quite often.

By the way, make a backup of your database before testing it out as it is not yet error-proof.

Thanks shadowfax. Here's a simple test with my dataset. Log in and wait for the first page to load, which is usually a list of invoices. That load takes 4 minutes.

I'll see if I can find time to anonymise my dataset so you can use it as a test. There's no credit card data in it, it is just names, email address, and so on, so I might be able to substitute some sort of random data in its place for testing purposes using a few well-crafted queries.

I should also say that I currently have it running on an iMac, 2.33 GHz Core 2 Duo, 2 GB RAM. The webserver it was previously running on was a little slower than that, but still capable of serving thousands of page impressions. Suggestions from others have been that one should have a 'proper' machine for running something like SI, suggestions which are, quite frankly, silly - something like Sage (a very common accounting package in the UK) will run on a Pentium II running Windows 95 and cope with much, much larger datasets than mine!

That would be awsome as I could test for performance...

I guess MySQL shouldn't have a hardtime with 1000 records, it must be and index related issue.

I have 5000+ invoices and my database loaded it in less than 1 sec. The main issue with the slow loading speed for SI is because it is calculating the 'aging' speed as well as the payment difference between paid and total amount. A few hacks will be needed to change that to not show until needed.

Let me know if you are looking into that

http://www.ebuyshipping.com wholesale cheap urban hip hop ED hardy Gucci Chanel Prada Designer Shoes ugg boots ...
http://www.ebuyshipping.com cheap wholesale Christian Louboutin, Gucci Shoes, Dsquared2 Shoes, Chanel Shoes, Ugg Boots, ATO Matsumoto, Louis Vuitton ,Adidas Shoes, Bape Shoes, Prada shoes, Puma Shoes, Hogan Shoes, Timberland Boots, Mauri Sneakers, Ed Hardy Shoes, Coach Shoes, Dolce Gabbana Shoes, Fendi shoes, Versace Shoes, Evisu Shoes, Armani Shoes, Burberry Shoes, Coogi Shoes, Lacoste Trainers, Paciotti 4US shoes, Christian Audigier Shoes, Christian Dior Shoes, Richmond Shoes,Converse Shoes...