☰
Current Page
Main Menu
Home
Home
Editing Performance
Edit
Preview
H1
H2
H3
default
Set your preferred keybinding
default
vim
emacs
markdown
Set this page's format to
AsciiDoc
Creole
Markdown
MediaWiki
Org-mode
Plain Text
RDoc
Textile
Rendering unavailable for
BibTeX
Pod
reStructuredText
Help 1
Help 1
Help 1
Help 2
Help 3
Help 4
Help 5
Help 6
Help 7
Help 8
Autosaved text is available. Click the button to restore it.
Restore Text
#Performance ##Question How well does Izenda perform on large databases? ##Answer ###Scalability Izenda scales well to systems with ~250 users per cpu. Response times on reporting pages will generally run about 4 seconds under these conditions. Izenda serves many multi-tenant clients using clustered databases as well as load-balanced multi-terabyte databases. ###Exporting Large exports with 100k+ records need to be done in [[Bulk CSV format|http://wiki.izenda.com/FAQ/Formatting/How-do-I-Add-bulk-CSV-to-the-report-viewer]]. This is designed to stream the data in parts instead of one large download. This prevents browser timeouts by immediately pushing records to the requesting client. This way, if the full export takes 5 minutes and the browser times out in 1 minute, Izenda can use streaming capabilities to keep the browser active and the client will receive the entire file. ###Queries Izenda creates smart queries instead of pulling all data at once. So if you need a report for each state and there are a billion records, Izenda will only pull an x record summary out of the database, where x is the number of records specified in the report definition. This means much faster response times as opposed to processing all of the billion records. You can set the limit of records per-report and per-dashboard. Izenda is typically faster than the database so the query time tends to be the bottleneck. For this reason, it's important to create indexes and views.
Uploading file...
Header
 **This documentation is for the legacy Izenda 6 product. Documentation for the new Izenda 7 product can be found at [[https://www.izenda.com/docs/|https://www.izenda.com/docs/]]**
Sidebar
 --- * [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]] * [[Release Notes]] * [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]] * [[FAQ]] * [[Tutorials]] * [[The Izenda API|/API/AdHocConfig]] * [[The AdHocSettings class|/API/AdHocSettings]] * [Developer Links and Guides](/Guides/Developer-Links-and-Guides) * [[Known Issues]] --- * <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a> * [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A) * <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a> * <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a> * <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a> --- * [Guide To Report Design](/Guides/ReportDesign) * [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs) --- * [[Acknowledgements]]
Edit message:
Cancel