I have a product database containing a wealth of information from products - e.g. posters, books, etc...
this information shall displayed in a DruPal module...
As I understand the whole database must be converted into a "Drupal"-node, hence duplicating the information, which is a bit hard, given that we have 5 million articles and aprox 20 million relations between those articles and categories
for an example schema you can look at the [url removed, login to view] site
- Category to Category Relations
- Category to Product Relation
- descriptions for all of the above
These products shall be displayed as Drupal nodes, navigation and categories should use the Drupal Taxonomy
Based on that various features like rating, commenting, filtering and search shall be done using Drupal standard features
Performance IS an issue...
displaying, searching 150k records must perform well
Please propose a solution to
A) import the existing product database
B) access the existing product database similar to a node in drupal
This project will only be accepted if a test run with 150,000 product records will perform well (i.e < 1 sec response for all questions) on a dual-core/dual opteron server with 2 GB RAM for all search queries specified
I can supply the full product database as MYSQL export (700meg) for development & testing
A more detailled programming spec is available and will be given to serious bidders.
and the drupal modules
Print Friendly Pages
as well as all standard features of drupal
Delivery of completed system within 14 days required.
- installation of the test system on my dual/dual core/server
for performance and migrations tests 40%
- full working install of the final system on my server 20%
- acceptance test for 10 days until release of full payment 20%
- all modifications of drupal and/or additional modules in a
separate package including list of necessary installation steps. 20%