search

datacenter / acitoolkit

A basic toolkit for accessing the Cisco APIC
Other
348 stars 266 forks source link

Endpoint Tracker - loads too slow with large amount of entries #167

Open leon-rz opened 8 years ago

leon-rz commented 8 years ago

I have over 100k entries and flask isn't up to the task of displaying all of them in a timely fashion, I don't think using a dedicated HTTP server will help either ( gunicorn didn't help ). So what can be done to improve the performance ? multi-threading or using cache ?

michsmit99 commented 8 years ago

Is this issue strictly related to the GUI ? Are you able to query the SQL database directly ?

leon-rz commented 8 years ago

MySQL has no issues. Only the flask web app isn't able to handle the large amount of data. Query the database directly is fast

Thanks Peter

Sent with Good (www.good.com)

From: Michael Smith notifications@github.com Sent: Friday, February 12, 2016 6:17:13 PM To: datacenter/acitoolkit Cc: Zhang, Peter Subject: Re: [acitoolkit] Endpoint Tracker - loads too slow with large amount of entries (#167)

Is this issue strictly related to the GUI ? Are you able to query the SQL database directly ?

Reply to this email directly or view it on GitHubhttps://github.com/datacenter/acitoolkit/issues/167#issuecomment-183523632.

Confidentiality Notice: This electronic message transmission, including any attachment(s), may contain confidential, proprietary, or privileged information from Chemical Abstracts Service ("CAS"), a division of the American Chemical Society ("ACS"). If you have received this transmission in error, be advised that any disclosure, copying, distribution, or use of the contents of this information is strictly prohibited. Please destroy all copies of the message and contact the sender immediately by either replying to this message or calling 614-447-3600.