Pete, Sorry if I sounded a bit uptight with my last posting. I'm really not. I just want this project to be successful and if you feel you can help me on this one problem I'm having, I do really appreciate your feedback!!!
I do have a question. I visited your spanish holiday bookings website. I was just wondering, do you have a database driving your website's content? If you do, are you satisfied with how many tables you are using to store data in terms of the time it takes to access records using queries? About how many records do you have? This may help me with making my decision; that is if you can give me a practical "real world" scenario that will give me something to compare my project to. Thanks in advance! - William --- In [email protected], Pete <[EMAIL PROTECTED]> wrote: > > In message <[EMAIL PROTECTED]>, wrwatson2003 > <[EMAIL PROTECTED]> writes > >I do know for a fact that there will be over 10,000 records put into > >the database immediately once the project is finished. > > There will be about 90 fields, one for each checkbox. Each field will > be quite small - assuming that you are using MySQL, they will be > probably be TinyInts, so won't take a lot of space. > > > I don't think > >having 900,000 fields to filter through in one table is a good idea! > > I can't figure out what you mean here... > > >I was told by an MCSD that the more tables I have, the better. > > No, because YOU will have to open 4 tables instead of opening one! > > >I'm not really sure why I thought I would need 4 tables. I'm looking > >for a way to minimize the number of fields my queries have to search > >to retrieve data. > > You have actually made it more complicated, because now you have the > same number of fields, but spread across 4 tables. > > >Can you help me? What do you suggest I do? > > Create 1 table! If you really need to, create a field "oldtablenumber" > which will show which table the records "used" to be in, just to keep > your head together. > > -- > Pete Clark > > http://www.hotcosta.com > http://www.spanishholidaybookings.com > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
