Title: growing database
Last modified: January 7, 2024

---

# growing database

 *  Resolved [Karol](https://wordpress.org/support/users/lewshop/)
 * (@lewshop)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/growing-database-3/)
 * After checking the database, I noticed that omnibus adds a lot of _iwo_price_lowest
   and _iwo_price_log. After each product update, a new record is added, which causes
   my database to swell. Even if I do not change the price, a new line is added.
   Do you have any ideas on how to avoid clogging the database?
 * [https://prnt.sc/U2FjLM2qMH6j](https://prnt.sc/U2FjLM2qMH6j)
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fgrowing-database-3%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Plugin Author [Marcin Pietrzak](https://wordpress.org/support/users/iworks/)
 * (@iworks)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/growing-database-3/#post-17324273)
 * Hi [@lewshop](https://wordpress.org/support/users/lewshop/)
   I’ll check because
   it shouldn’t be like this. It should only be saved during the change.I will try
   check it as soon as possible: [https://github.com/iworks/omnibus/issues/22](https://github.com/iworks/omnibus/issues/22)
   Marcin
 *  Plugin Author [Marcin Pietrzak](https://wordpress.org/support/users/iworks/)
 * (@iworks)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/growing-database-3/#post-17327123)
 * [@lewshop](https://wordpress.org/support/users/lewshop/)
 * Aktualizacja 2.5.4 mam nadzieję, że spowoduje zaprzestanie nieoczekiwanego wzrostu
   bazy. Możesz sprawdzić?
 * I dodałem ticket na nowe ustawienie: [https://github.com/iworks/omnibus/issues/23](https://github.com/iworks/omnibus/issues/23)
 * Dziekuję!
 * Marcin
 *  Thread Starter [Karol](https://wordpress.org/support/users/lewshop/)
 * (@lewshop)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/growing-database-3/#post-17332978)
 * ok. sprawdzę, chcę teraz usunąć wszystkie rekordy aby posprzątać w bazie: _iwo_price_lowest,
   _iwo_price_last_change. Nie spowoduje to problemu z wtyczką?
 *  Thread Starter [Karol](https://wordpress.org/support/users/lewshop/)
 * (@lewshop)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/growing-database-3/#post-17335930)
 * Mogę prosić o odpowiedź?
 *  Plugin Author [Marcin Pietrzak](https://wordpress.org/support/users/iworks/)
 * (@iworks)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/growing-database-3/#post-17337449)
 * > ok. sprawdzę, chcę teraz usunąć wszystkie rekordy aby posprzątać w bazie: _iwo_price_lowest,
   > _iwo_price_last_change. Nie spowoduje to problemu z wtyczką?
   >  [@lewshop](https://wordpress.org/support/users/lewshop/)
 * Zniknie poprzednia cena.
 * Mam dopisane zadanie, żeby umożliwić automatycznie usuwanie starszych zmian, 
   więc mam nadzieję, że możesz poczekać.
 * Jak nie, to można spróbować usunąć – ale np. tylko takie co się powtarzają:
 *     ```wp-block-code
       select count(*) from wp_postmeta
          where meta_key = '_iwo_price_last_change'
          group by meta_value
          having count(*) > 1;
       ```
   
 * Marcin
 *  Plugin Author [Marcin Pietrzak](https://wordpress.org/support/users/iworks/)
 * (@iworks)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/growing-database-3/#post-17343497)
 * HI [@lewshop](https://wordpress.org/support/users/lewshop/)
 * New (alpha) version should not duplicate entries. but it utilize a bit more DB,
   but should be faster 😀 (in the process of data migration duplicates shout be
   removed).
 * No to try on production:
 * [https://wordpress.org/support/topic/testy-nowej-wersji-3-0-0-alpha1/](https://wordpress.org/support/topic/testy-nowej-wersji-3-0-0-alpha1/)
 * Could you contact me and share DB backup before migration? (for tests).
 * marcin in domain iworks in the country pl
 * Marcin

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘growing database’ is closed to new replies.

 * ![](https://ps.w.org/omnibus/assets/icon.svg?rev=2840819)
 * [Omnibus — show the lowest price](https://wordpress.org/plugins/omnibus/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/omnibus/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/omnibus/)
 * [Active Topics](https://wordpress.org/support/plugin/omnibus/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/omnibus/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/omnibus/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [Marcin Pietrzak](https://wordpress.org/support/users/iworks/)
 * Last activity: [2 years, 4 months ago](https://wordpress.org/support/topic/growing-database-3/#post-17343497)
 * Status: resolved