I need help with subdomains

vigour

I don't know if this is the right forum for this, please tell me if not.

I have a domain with several subdomains, one for each customer.

Example:

subdomain1.domain.com

subdomain2.domain.com

I have a picture database (mysql) in the root of the domain because I want my customers to access the same same PHP scripts, so when a change is made to a script, every customer get the update.

The idea is to set a path to the picture folder (located in each subdomain) in the index file. The reason is that a customer may have a image with the same filename as another customer, so I can't have one picture folder for all customers. I plan to store the path in a session variable.

The url I get in my browser when I first hit the page is subdomain1.domain.com and that is fine. But when I click the link to get to the index page in the root of my domain I get the following url, subdomain.domain.com/index.html

Is it possible to get rid if the index.html part of this url. Or maybe I can build it in a completely different way. Please let me know what you think.

mikewhy

Maybe add a customer id field to the picture table that way duplicate file names wont matter. Then when the customer opens their page run something like SELECT images FROM image_table WHERE customer_id EQUALS...

vigour

That would work if I store the images in the database. But I only store the filenames in the database, I then build a path to the picture folder.

mikewhy;10903607 wrote:
Maybe add a customer id field to the picture table that way duplicate file names wont matter. Then when the customer opens their page run something like SELECT images FROM image_table WHERE customer_id EQUALS...

dagon

why not have a db table per customer

vigour

Because I want to be able to search in all images at the same time.

dagon;10903626 wrote:
why not have a db table per customer

dagon

you can search multiple tables at once,

vigour

I understand that I can do that with join.

What is the fastest, to have all data in one big table or to use multiple tables and search all tables at once? Is there a big difference in speed? I think the tables will have around 100000 rows each.

dagon;10903661 wrote:
you can search multiple tables at once,

bradgrafelman

I would think one single table, since if you searched multiple tables then the DBMS most likely has to open multiple storage files on the disk.