errr throughout => throw out :)
On 3/14/07, Marlon Moyer <[EMAIL PROTECTED]> wrote:
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"
--
"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/
