Title: DB table needs restructuring
Last modified: April 28, 2020

---

# DB table needs restructuring

 *  [Budiony Damyanov](https://wordpress.org/support/users/budiony/)
 * (@budiony)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/db-table-needs-restructuring/)
 * I have encountered errors when parsing URL from warmup table `swift_performance_warmup`.
 * The cause is that the database field `url` is `VARCHAR(255)` by default, which
   is not enough for long URLs, or if URL contains non-latin characters, as was 
   in my case.
 * Setting this field to `VARCHAR(2048)` solved the problem: now all URLs can be
   read properly and indexed, otherwise there was an error 404 – which is obvious,
   because **by default MySQL server cuts the long URL up to field length** limit
   without throwing notice or warning.
 * Besides that, the plugin is great, well-written source code, all database queries
   use prepared statements, security practices are implemented well.
 * So, SWIFT, please update the database structure in the next version!
 * P.S.: Also, update simple HTML DOM parser to at least version 1.9.1, the used
   version 1.5 (even modified in-house) has bugs.
    -  This topic was modified 6 years, 1 month ago by [Budiony Damyanov](https://wordpress.org/support/users/budiony/).
    -  This topic was modified 6 years, 1 month ago by [Budiony Damyanov](https://wordpress.org/support/users/budiony/).

The topic ‘DB table needs restructuring’ is closed to new replies.

 * ![](https://ps.w.org/swift-performance-lite/assets/icon-256x256.jpg?rev=2388229)
 * [Swift Performance Lite](https://wordpress.org/plugins/swift-performance-lite/)
 * [Support Threads](https://wordpress.org/support/plugin/swift-performance-lite/)
 * [Active Topics](https://wordpress.org/support/plugin/swift-performance-lite/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/swift-performance-lite/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/swift-performance-lite/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [Budiony Damyanov](https://wordpress.org/support/users/budiony/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/db-table-needs-restructuring/)
 * Status: not resolved