Title: Performance & Best Practices
Last modified: September 21, 2022

---

# Performance & Best Practices

 *  Resolved [lynoo](https://wordpress.org/support/users/lynoo/)
 * (@lynoo)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/performance-best-practices/)
 * Hi,
    I have noticed the bigger the data source file, the worse the performance
   of pages created in MPG becomes, I mainly mean page load speed here, I assume
   that when the file is big it will take time to search or sort.
 * Unfortunately, I can’t find in the documentation or in here anything helpful 
   regarding this, so here are my questions hoping to get some help.
 * Let’s say the data source file contains in the range of 100k to 400K rows,
 * 1- What would be the better option, uploading the data file, or using google 
   sheets?
    2- Which format is better and faster: .CSV or .xlsx? 3- Does splitting
   the file into multiple files, each as a project, help with performance or makes
   it worse? 4- If splitting helps, approximately, how many rows per file is optimal?
   5k or 10k ..etc? 5- caching to DB vs Disk? which is faster? I assume to disk 
   since it will become like a static page, but I could be wrong! 6- any other plugins,
   or ways that might help with performance?
 * Thanks

Viewing 1 replies (of 1 total)

 *  [luciamarinescu](https://wordpress.org/support/users/luciamarinescu/)
 * (@luciamarinescu)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/performance-best-practices/#post-16064160)
 * Hi [@lynoo](https://wordpress.org/support/users/lynoo/),
 * Thanks for choosing MPG and sorry for the delayed reply!
 * I’ll answer your questions punctually.
 * 1 – Uploading the file would be a better option.
    2 – CSV is generally faster
   and less complicated when compared to xlsx. 3 – File splitting is a good option
   and it helps fetch the data quicker. 4 – From our experience, a number of rows
   around 5k-10k per file should be ok. 5 – Caching to DB is generally faster. 6–
   As one example, we could point to the [Redis](https://wordpress.org/plugins/redis-cache/)
   plugin to help improve performance.
 * Have a nice day ahead!

Viewing 1 replies (of 1 total)

The topic ‘Performance & Best Practices’ is closed to new replies.

 * ![](https://ps.w.org/multiple-pages-generator-by-porthas/assets/icon-128x128.
   gif?rev=3274397)
 * [MPG – Multiple Page Generator, Bulk Landing Pages & Programmatic SEO](https://wordpress.org/plugins/multiple-pages-generator-by-porthas/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/multiple-pages-generator-by-porthas/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/multiple-pages-generator-by-porthas/)
 * [Active Topics](https://wordpress.org/support/plugin/multiple-pages-generator-by-porthas/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/multiple-pages-generator-by-porthas/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/multiple-pages-generator-by-porthas/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [luciamarinescu](https://wordpress.org/support/users/luciamarinescu/)
 * Last activity: [3 years, 7 months ago](https://wordpress.org/support/topic/performance-best-practices/#post-16064160)
 * Status: resolved