Thank you!
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marlon Moyer Sent: Wednesday, March 14, 2007 10:40 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: Re: [DFW CFUG] xml, etc. >From a high level, I'd have something set up like so: destinations: ------------------ id name etc dates: ------------------ id destination_id date etc. departures: ------------------ id date_id time etc. arrivals: ------------------ id date_id time etc. I'd quickly throughout the departure_1, departure_2 idea just because it makes querying the database a PITA real quick. If they only have 2 departure times, you have to check for nulls. You have to programmatically make sure that departure_1 is earlier than departure_2, etc. With the correct indexing, your database would sail through simple queries required here. On 3/14/07, Kevin <[EMAIL PROTECTED]> wrote: > > > > > Well, to go back to my example, The cruise in april has departure times and > pickup times for each day. However, all of these are different. > > > > The problem with the db option is that if I had a cruise_time table I would > have to have a number of fields defined for departure_1, departure_2, > departure_3 as well as pickup_1, pickup_2, pickup_3 for each product. I was > thinking that xml might be helpful because we could have > > > > <date> > > <departure> > > <time>time1</time> > > <time>time3</time> > > </departure> > > <return> > > <time>Time1</time> > > <time>time2</time> > > <time>time3</time> > > </return> > > </date> > > > > Again, maybe I'm just not approaching the database correctly. The system is > currently using the db to manage all of the times. I am trying to find the > easiest and most robust solution. So XML is out I guess? > > > > > Kevin > > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Tim Hoffman > Sent: Wednesday, March 14, 2007 10:01 PM > To: 'Dallas/Fort Worth ColdFusion User Group Mailing List' > Subject: RE: [DFW CFUG] xml, etc. > > > > > I'm not quite getting it either. Can you give us a more concrete example? > > > > Tim > > > > ________________________________ > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Marvin Eads > Sent: Wednesday, March 14, 2007 10:01 PM > To: Dallas/Fort Worth ColdFusion User Group Mailing List > Subject: Re: [DFW CFUG] xml, etc. > > > > > > I had the same thought. I just figured I didnt quite understand his needs. > > XML is extremely verbose. Putting that many products with all your hours > and days into XML will result in a huge file. Large datasets is exactly > what databases are for. > > Maybe you need to be more clear about your logic in thinking XML is a > better choice. I may just not be getting it. > > Marvin > > > ----- Original Message ---- > From: Marlon Moyer <[EMAIL PROTECTED]> > To: Dallas/Fort Worth ColdFusion User Group Mailing List > <[email protected]> > Sent: Wednesday, March 14, 2007 9:47:30 PM > Subject: Re: [DFW CFUG] xml, etc. > > > I'm not clear why you think that a database wouldn't be a good place > to store 8000 products? > > As for xml of that size, unless you read it once and then store it in > memory, it will be extremely slower than using a db to query the > information. > > > On 3/14/07, Kevin <[EMAIL PROTECTED]> wrote: > > > > > > > > > > I think that I have asked this before...if so I must not have received and > > answer. > > > > > > > > I have an application that is booking reservations for various cruises. > > The cruise goes every day but each day has different times. There is not > > the ability to simply set up a table for mon, tues, wed, etc. with times. > > For example, in April, 15 of the days have the same time and the others > all > > have different times. > > > > > > > > I was thinking that I would put this in an XML file rather than in the > > database. Anyone have any ideas how we would best achieve the > flexibility > > of storing and serving all of these times? It seems that XMLParse is not > > real fast. One other thing to note....we have 8000 products....this is why I > > was thinking that we would not store all of this information in a > database. > > > > > > > > Any help would be appreciated. > > > > > > > > Thanks, > > > > > > > > Kevin > > _______________________________________________ > > Reply to DFWCFUG: > > [email protected] > > Subscribe/Unsubscribe: > > http://lists1.safesecureweb.com/mailman/listinfo/list > > List Archives: > > http://www.mail-archive.com/list%40list.dfwcfug.org/ > > http://www.mail-archive.com/list%40dfwcfug.org/ > > DFWCFUG Sponsors: > > www.instantspot.com/ > > www.teksystems.com/ > > > > > > > -- > "Donnie D's on the backup, > drug free so put the crack up. > No need for speed, > I'm anti d-r-u-g-g-i-e" > > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.instantspot.com/ > www.teksystems.com/ > > > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.instantspot.com/ > www.teksystems.com/ > > -- "Donnie D's on the backup, drug free so put the crack up. No need for speed, I'm anti d-r-u-g-g-i-e" _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/ _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
