My customer has 200+ addresses, the page takes a long time to respond(this is one issue),and other is when I try to save some changes,I am getting error as shown in pic.If customer has few addresses, it is (loading, saving) is working fine.I am unable to trace any thing about long time to respond and issue on Save for large no of addresses, any help, guide will be appreciated. Thanks in advance.
I've run into this issue as well previously, although not directly related the same issue was occuring on a large number of customer records, some had 100+ addresses in their address book.
The best advice unfortunately is to create an indexed (flat table) of your own of the customer's address book. This would most likely optimize and/or speed up the slow loading times. If it's an edge case of only very few customers then you'd most likely be better off taking the DB optimization approach and/or bumping up DB server memory to hold all of the results in cache.
The quick win would also be to optimize your
my.cnf settings of MySQL to try and cache as much as possible for the lookup of the request(s) using mysqltuner.pl or mysqlprimer.pl scripts and tweak the innodb settings specifically. NOTE: These are merely for advice and as a guide, always best to measure performance when changing settings.
Again, if this is an edge case however, perhaps limiting the collection and or digging out the specific ID from the database itself to return if needing to edit from the admin specifically. If the issue is also on the frontend to the customer then paginating the results would be best.
There is also this but looks to be from 1.5CE, but may possibly help some as well: