I am developing an application were their is no bound on number of records so i have decided to store all the data in form of XML rather then in relational database.
That decision may be very premature. Time to back off a bit and take another look at the problem. Start by answering the following:
1. How will the data be retrieved for use?
2. Once a record has been located, how will it be used?
3. Will the process that uses retrieved records ever need to look at more than one at a time?
4. Will records ever be modified?
5. Will new records ever be added?
Bill