Mar-01-2017, 12:53 AM
How long does it take to get the acl for a single firewall? I feel like 15 minutes is still a huge amount of time, unless you're spending most of that time just waiting for the device to respond.
For the mysql tables, are there indexes in place? How many rows? Over an hour just to add some records is also a little ridiculous. How many acl rules are you getting at once? Is it several thousand? When inserting, do you insert each individually, or have a single insert statement for all of them?
Before talking multiprocessing, I think it'd be worthwhile to figure out why it's so slow to begin with...
For the mysql tables, are there indexes in place? How many rows? Over an hour just to add some records is also a little ridiculous. How many acl rules are you getting at once? Is it several thousand? When inserting, do you insert each individually, or have a single insert statement for all of them?
Before talking multiprocessing, I think it'd be worthwhile to figure out why it's so slow to begin with...