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/
