Hi all,
I would like to create an Business Directory type of application where registered users would be able to upload their entries together with a maximum of 5 images.
now for performance reasons I do not want to store the textual information on the same table as the images (I want all columns on the entry table to be of fixed length, fully searchable etc).
ideally i would have
- a table called entry_text with columns entry_id,title, description, image_id1, image_id2, image_id3 etc
- a table called entry_images with columns image_id and image (blob)
would this be something that phprunner could handle? maybe using a master-detail?
In general what would be the best practice?
thanks in advance