Probably so ;)
We are using mySQL and it is working OK. I believe that the current system needs some tweaking and not an "overhaul". I just wanted to post this to the group. Thanks for the responses. Kevin From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Skipper Pickle Sent: Wednesday, March 14, 2007 10:24 PM To: 'Dallas/Fort Worth ColdFusion User Group Mailing List' Subject: RE: [DFW CFUG] xml, etc. Er, you don't want to maintain 8000 xml files, do you? What database are you using? SQL Server or MySQL should be able to handle this well. It sounds like your real question is about how to structure the database. --- Skipper Pickle 972.978.5807 ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Sent: Wednesday, March 14, 2007 10:15 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: RE: [DFW CFUG] xml, etc. One other thing to note. I would go to the cruise and review the times. So I would not need all of the products in one file. Each product would have their own xml file..... -------------------------------------------------------- Kevin Fricke Lone Star Media [EMAIL PROTECTED] Office: (512) 371-1822 Mobile: (512) 626-0528 Fax: (512) 597-0909 Toll Free: (877) 791-7083 http://www.lonestarmedia.com 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/
