Access vs. XML
a. Will Access give me the performance boost I'm seeking?
b. Will it make code easier to maintain?
c. Are there any caveats to watch out for?
Can you give a small sample?
All queries start at the top of the file and read every record all the way to the end of the file. :(
Also, doing join queries are a nightmare in XML.
I think I will definitely explore Access. It has to be a better solution than XML.
BTW - Construct is just another word for 'build '
Senior Developer
Thanks for the comment. I have one last comment.
True, writing to disk can be slow. To be more specific; writing to a database is much slower than writing to XML because database updates require update to indexes, etc. which can make lengthen the updating process depending of the number of rows and columns to be updated. XML; on the other hand is pretty straightforward, just append the data to the file. However, in my situation it does not matter.
a. The data, for the general user, will be read only . Admin will be the only user updating the data.
writing to disk can be slow.
In general, that is not the case. Writing a plain file is pretty fast.
All queries start at the top of the file and read every record all the way to the end of the file. :(
Also, doing join queries are a nightmare in XML.
That is exactly the point. And that is what the database engine solves by indexing the data and caching the data for multiple reads.
/gustav
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions