Hi All,
I have been using MySQL for some time in a basic and simple manner to
retain prompt information and data for my multilingual websites.
My new project is however a much larger matter.
The site is a repository for advertisements advertising vehicles. This
includes land sea and air vehicles and basically anything that carries
people.
My questions are:
What is the optimum way to structure the database to allow for the
simplest user search?
Is it more efficient to store images and large documents in their
respective format on disc and the URL in the database or as blob objects?
A requirement is that searches will be entered in many languages
including all European, Asian and middle-eastern languages and scripts.
This may also be mixed languages where manufacturer name may be in the
middle of say Japanese script.
Further, my clients expect the site to grow over a period of three years
from 4 initial languages to around 50 and service many more countries.
I have defined so far a range of categories and sub categories, types,
manufacturers etc. I also intend to carry advertiser data, country,
language and images. Included may also be uploaded documents being
detailed specifications of vehicles in PDF and other formats although
they may be outside the search criteria (???)
My knowledge of applying single field search (ala Google) to multiple
tables is decidedly limited and I don't want to find myself in deep
water due to lack of specific knowledge.
If this is off topic please accept my apologies and if possible direct
me to an appropriate forum.
Thanks
Rob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
