By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,990 Members | 2,138 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,990 IT Pros & Developers. It's quick & easy.

PERFORMANCE QUESTION

P: n/a
I want to built a web page which is gonna have multiple languages. Which one
is the best way ? Using a Xml file to store languages and their
corresponding fields or Using a MS-SQL Database ?

What do you recommend me to have best performance about multilanguage
web-sites?
Mar 30 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
if you are worried about performance, the localized content should be stored
in the cache, which means whether you use XML or a database, the performance
will be excellent.

Karl
--
http://www.openmymind.net/
http://www.fuelindustries.com/
"Savas Ates" <in da club> wrote in message
news:Os**************@TK2MSFTNGP12.phx.gbl...
I want to built a web page which is gonna have multiple languages. Which
one is the best way ? Using a Xml file to store languages and their
corresponding fields or Using a MS-SQL Database ?

What do you recommend me to have best performance about multilanguage
web-sites?

Mar 30 '06 #2

P: n/a
It really depends. For large numbers of records, SQL will far outperform
XML. Parsing XML is a relatively slow thing. If you are going to have 10K
records with information regarding different words in different languages,
XML is going to be slow, and so will XPath.

If you have 200 records, well, maybe it doesn't matter as much.

Also, you can use Access as your database, which is file based, so similar
to an XML file in that regard.

You should look at your situation, and see what works best for you. The key
is to box up all the translation code into some methods, so if you switch
implementations, only those few methods have to change.

"Savas Ates" <in da club> wrote in message
news:Os**************@TK2MSFTNGP12.phx.gbl...
I want to built a web page which is gonna have multiple languages. Which
one is the best way ? Using a Xml file to store languages and their
corresponding fields or Using a MS-SQL Database ?

What do you recommend me to have best performance about multilanguage
web-sites?

Mar 30 '06 #3

P: n/a
File I/O is simple and no network operation needed.... But again if you are
delpoying to a server, will it be easy to get deployed and get read access
or read-write for the XMLfile?

personally i will go with DB, if your application is already using a
Database for other purposes.. the reason is updating is easy... or else you
have to find ways to deploy the new XML file to the server... might be
painful sometimes..

if you don't have a DB in the app... do a XML file...

VJ

"Savas Ates" <in da club> wrote in message
news:Os**************@TK2MSFTNGP12.phx.gbl...
I want to built a web page which is gonna have multiple languages. Which
one is the best way ? Using a Xml file to store languages and their
corresponding fields or Using a MS-SQL Database ?

What do you recommend me to have best performance about multilanguage
web-sites?

Mar 30 '06 #4

P: n/a
JT
There is a standardized feature in ASP.NET for binding the text properties
of web controls with alternate content, stored in XML based "resource
files", keyed on the language settings of the user's browser.
http://msdn2.microsoft.com/en-us/lib...27(VS.80).aspx
"Savas Ates" <in da club> wrote in message
news:Os**************@TK2MSFTNGP12.phx.gbl...
I want to built a web page which is gonna have multiple languages. Which
one is the best way ? Using a Xml file to store languages and their
corresponding fields or Using a MS-SQL Database ?

What do you recommend me to have best performance about multilanguage
web-sites?

Mar 30 '06 #5

P: n/a
Savas,

Is this real a question. Whatever system your choose is the only moment that
it can be from importance be as the user changes the language. As most use
the by IE returned standard information in what is the language and than a
Cookie if that changes, what is a one time operation. For the rest it is
equal to getting all kind of information.

Just my thought,

Cor
Mar 30 '06 #6

P: n/a
On Thu, 30 Mar 2006 20:22:04 +0200, "Cor Ligthert [MVP]"
<no************@planet.nl> wrote:
in <Ok**************@TK2MSFTNGP11.phx.gbl>
Savas,

Is this real a question. Whatever system your choose is the only moment that
it can be from importance be as the user changes the language. As most use
the by IE returned standard information in what is the language and than a
Cookie if that changes, what is a one time operation. For the rest it is
equal to getting all kind of information.

Just my thought,

Cor


Well, good that we cleared that one up a bit.

---
This posting is provided "AS IS" with no warranties, no guarantees, and no conferred rights.

Stefan Berglund
Mar 30 '06 #7

P: n/a
Yep, clear as mud (as Cor's posts usually are, from memory).

--
*mike hodgson*
http://sqlnerd.blogspot.com

Stefan Berglund wrote:
On Thu, 30 Mar 2006 20:22:04 +0200, "Cor Ligthert [MVP]"
<no************@planet.nl> wrote:
in <Ok**************@TK2MSFTNGP11.phx.gbl>
Savas,

Is this real a question. Whatever system your choose is the only moment that
it can be from importance be as the user changes the language. As most use
the by IE returned standard information in what is the language and than a
Cookie if that changes, what is a one time operation. For the rest it is
equal to getting all kind of information.

Just my thought,

Cor


Well, good that we cleared that one up a bit.

---
This posting is provided "AS IS" with no warranties, no guarantees, and no conferred rights.

Stefan Berglund


Mar 30 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.