We now have an enormous database (4GB) and largely are wp_posts questioning if is that attainable to love, cut up it to 2 completely different databases to have higher efficiency?
for instance, cut up submit sorts with PRODUCT to second database, and when shopper asks to fetch merchandise, WordPress ask information from DB2 instantly, not asking DB1 and redirect to DB2.
Hope my query is sensible.