XML data question

[Eric S]

Hi All,

I have about 8 small pick list Like States, Countries, CreditCard etc... I
was thinking maybe it could be a good idea to have 8 XML files
to be stored on the HD instead of opening that connection and bind the data
from the tables all the time.

Using the XML files instead, would that be good idea?

Thanks,

Eric

 

[Mr. Arnold]

Hi All,

I have about 8 small pick list Like States, Countries, CreditCard etc...
I was thinking maybe it could be a good idea to have 8 XML files
to be stored on the HD instead of opening that connection and bind the
data from the tables all the time.

Using the XML files instead, would that be good idea?

Thanks,

Eric

A SQL server table has an XML data type to if you're using SQL Server
2005 and above. We have some XML data on SQL server and we have XML
files on the network share accessible by applications running on the Web
server.

 

[Eric S]

Hi Arnold,

I am using ms sql 2008 and trying to figure if using XML instead of tables
for picklist would be faster while loading the web site.

Thanks,

Eric

 

[sloan]

Both ideas are viable.

"Faster"...maybe.

Relevantly faster? Not so sure.

..........

Look at Caching. That would be faster than reading the datastore everytime.
Especially static data like a state list.

.........

At some point, it may be a maintenance over a performance issue. States are
fairly concrete ( Washington DC is still holding out hope for statehood).

My advice is to not overthink it to the point of out clever'ing yourself.
If you read it from the db and use a caching option.............then you'll
never notice a performance issue.

..................

A simple google search (errrr....bing search) shows:
http://www.google.com/#hl=en&source...i=g10&oq=asp.net+caching+&fp=aa0e561cd8821793
http://www.bing.com/search?q=asp.net+caching+best+practices&go=&form=QBLH&qs=n

 

[Eric S]

Hi Sloan,

Thanks for your reply.

I guess you are talking for database caching if I am not mistaken. Once
those tables are opened then they are all cached on ms sql 2008(Enterprise
version 64 bits).
On the other hand I don't need to create any database connection to grab the
tables(8 of them) if they are as XML.

Regards,

Eric