Imagine do u have application where the user can built his own report visually (ie: one form with differents fields of the table in database and u want to built the report output, Employees from the sales department where the amount of their sales is greather than 30 000 dls )...the imagine u can save in the server the schema of that report , then when other user connect to u application can use this report only changing the criteria 30 000 ...If u try to save this schema in some relational database the amount of time u will need to translate it will be greather than in XML file
Example <Report> <Title id="1">Sales amounts</Title> <...> <...other data> <DEFANGED_SELECT>Select field 1, field2, field3 from Table1 INNER Joing ...etc,etc...more complex sql </DEFANGED_SELECT> <CriteriaFields> <Field name="field2"> <PredecessorOperator>">"</PredecessorOperator> <FieldValue>30000</FieldValue> <NextLogicOperator>AND</NextLogicOperator> </Field> <Field name="field3"> <PredecessorOperator>"="</PredecessorOperator> <FieldValue>Sales Department</FieldValue> <NextLogicOperator></NextLogicOperator> </Field> </CriteriaFields> </Report> It's just an example..... __ M.Sc. Hassan Arteaga Rodríguez Microsoft Certified System Engineer IT Specialist DIGI Grupo de Desarrollo. COPEXTEL, S.A. Este email y sus adjuntos está dirigido solamente a los destinatarios consignados en el mismo y debe ser considerado confidencial. Si Ud. no es el destinatario consignado o la persona responsable de entregar/enviar el presente, no podrá copiarlo o entregarlo/enviarlo a ninguna otra persona ni utilizar el mismo en forma no autorizada. Dichas acciones están prohibidas y pueden ser consideradas ilegales. Si Ud. recibiese este email por error, por favor comuníquelo de inmediato al emisor del mismo. -----Original Message----- From: Johnny Le [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 9:46 AM To: CF-Talk Subject: XML faster? Is it faster to connect to an XML file than to a database? Assuming both store the same amount of data. I know that getting the data in and out is easier with a database, but I wonder if it is faster with XML. XML vs. Access? XML vs. SQL Server? XML vs. MySQL? XML vs. Oracle? Johnny ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182835 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54