PERFORMANCE QUESTION

[Savas Ates]

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?

[Karl Seguin [MVP]]

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?

[Marina Levit [MVP]]

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?

[Vijay]

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?

[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?

[Cor Ligthert [MVP]]

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

[Stefan Berglund]

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

[Mike Hodgson]

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