we want to integrate our quickbase functionality [online database]
our host offers 100mb databases and i have plenty available to me. after reviewing my existing logs and size of database for even a low traffic site, im concerned that the database that im constructing with cck, nodeimport, & node referrer, will bloat the db to well over 100mb considering that our sales record db alone weighs in at over 50mb. [many years of records that do need to be accessed to generate reports].
what i would like to do is specify that records added to my nodes configured for them, get stored in different databases. id like to use 3 additional but i would be content with just 1 additional for the sales records.
any idea how to go about this if its even possible?
Comments
=-=
one way may be to use a multisite install with the aid of subdomains.
for example: sales.yourdomain.com which has its own database and shared tables based on the array in settings.php
heres a slidshare presentation on how to accomplish multsites and sharing tables including users sessions and the like so that users only login a single time across subdomains.
while that certainly is an
while that certainly is an interesting way to solve the problem, i was reading up on this:
http://drupal.org/node/18429
where apparently it is easy to integrate several databases to your single drupal install.
so i was rethinking my approach. how about a custom module that functions as quickbase does. a drupal relational db module...
so i made a new db. made a table called inventory cz that my smallest existing db to test things out with, made some fields and imported the content via csv to phpmyadmin. db populated perfectly...the second time lol.
im currently doing the same for my sales records bcz the material name in inventory is relational to the same field in sales records and i want to get that set up before i try module making
so i have already completed the data entry form via cck that i will need. now how would i go about pointing that content type [labeled database in my case] to the separate db? should i be looking into a custom module for this?
=-=
I've no idea. Don't believe I've ever seen any documentation with reference to this either. My first guess would be a custom module with a custom content type that uses a custom db query but don't take my word for it at all.