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
