Ramesh Jangra
asked on
Handling large mysql database in php
Hi all,
We are developing a job portal in php and using mysql as database. Total number of fields to be stored in mysql are about 90. So here the challenges we are facing-
1. Shall we store all the fields in one table or distribute in separate tables.
2. How to store multiple entries in one field set like someone may have multiple certifications/qualificati on/degrees , since the qualification option is kept dynamic and user may enter as many as certifications etc.
Thanks
Ramesh
We are developing a job portal in php and using mysql as database. Total number of fields to be stored in mysql are about 90. So here the challenges we are facing-
1. Shall we store all the fields in one table or distribute in separate tables.
2. How to store multiple entries in one field set like someone may have multiple certifications/qualificati
Thanks
Ramesh
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://support.experts-exchange.com/customer/portal/articles/481419