Greetings,
I'm looking for some advice on building a portion of my web application.
Here's the scenario:
I need to build an XML file that can be downloaded to a user's desktop
for use in an offline, standalone FLASH application. What I'm doing now
is using CF to take content from a database, build an enormous XML file
and then the desktop application connects using a socket connection
(Using FlashStudio Pro), downloads the file and then uses the file as a
"database". The XML file will contain at least 5,000 entries and each
entry has multiple entries from another table related to it. So, I'm
looking at a gigantic XML file (5-15mb easilly). I just used CF to
generate a page for me and it took well over 5 minutes to run the
routine and output the results to a browser window. What I'm wanting to
do is have it write directly to a file but just for the sake of testing
I've been dumping the output to screen and copy/pasting into a document.
So, basically the document would look something like: (Abstracted due to
NDA issues)
<file>
<!-- Currently 4,500 Listings - will grow from here -->
<listing info1="content" info2="content" info3="content" ...
info12="content">
<!-- At least 1, but up to 10 instances inside a listing -->
<instance>
<!-- At least 30 questions inside an instance -->
<question info1="content" info2="content" info3="" ...
info15="content">
<answer info1="content">content</answer>
</question>
... AT LEAST 29 MORE QUESTIONS ...
<instance>
... UP TO 9 MORE LISTINGS ...
</listing>
... 4500+ MORE LISTINGS ...
</file>
Before I get too far into this, I'm looking for advice on another way to
generate the XML files that would be faster and less intensive on the
server. What about a JAVA application that runs in the background and
writes the XML documents? Would that be more efficient than using CF for
this task? Is there any way to schedule a JAVA application to run at a
certain time every day on a Windows server? If not, I suppose I could
use CF to initiate the process.
Another item to note - I'll be generating at least 50 of these documents
each day and maybe 100's.
Any input or advice greatly appreciated.
THANKS !!!
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net <http://www.garrisonenterprises.net/>
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
************************************************************************
*************
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of
Garrison Enterprises Inc.
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you
have received this e-mail in error please delete it immediately and
advise us by return e-mail to
<mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED]
************************************************************************
*************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
