You are here:  » Database Management / Recomendation


Database Management / Recomendation

Submitted by Antony on Sun, 2015-11-15 07:43 in

Hi David,

I have gone through a few topics on your forum and yet still struggle to get around what option would be best for me. In a scene I know that you have answered this question in many different ways so apologies for getting you back on this.

I'm on a shared hosting with X-amount of SQL database but each limited to 300MB of Disk Space.

300MB is not much as I'm hopping to build up with a rather large merchant list as well as categories and product volumes.

I have read about multiple install, top level search, categorizing installs, master installs, prefixed DB, Merchant categories, sub-domains, etc...

So in all, what would your structure suggestion be bearing in mind we would want something neat, organized and optimized?

PS: Love the script, well done, I really look forward to work on this.

Best,

Antony

Submitted by support on Mon, 2015-11-16 08:58

Hello Antony,

Thank you for your comments and welcome to the forum!

Check out this thread which contains download link and instructions for creating a top level multi-site search form.

You could start off with a general installation but if you use a sub-directory at the outset e.g. /shopping/, once you build out your site and go towards category based installations you can simply rename the first installation as required (it would also be straight forward to set-up 301 Moved Permanently redirections from specific categories to new installations in the future).

The first installation can then also become your "master" installation of sub-category installs - i.e. the one where you use the Automation Tool and keep all feeds, with subsequent installations set-up to point to the /feeds/ folder of the master installation.

You would then have cron.php scheduled on the master installation, and just import.php @ALL on the other installs, running a suitable time later to ensure that the fetching process has completed on the master installation.

If you're not sure about any stage of the process just let me know and I'll point you in the right direction...

Cheers,
David.
--
PriceTapestry.com