PERFORMANCE QUESTION

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?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:OsYNsoBVGHA.5500@.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?
>
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:OsYNsoBVGHA.5500@.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?
>
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:OsYNsoBVGHA.5500@.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?
>
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/library/ms227427(VS.80).aspx
"Savas Ates" <in da club> wrote in message
news:OsYNsoBVGHA.5500@.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?
>
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
On Thu, 30 Mar 2006 20:22:04 +0200, "Cor Ligthert [MVP]"
<notmyfirstname@.planet.nl> wrote:
in <Okh2caCVGHA.5580@.TK2MSFTNGP11.phx.gbl>

>Savas,
>Is this real a question. Whatever system your choose is the only moment tha
t
>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 c
onferred rights.
Stefan Berglund
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]"
><notmyfirstname@.planet.nl> wrote:
> in <Okh2caCVGHA.5580@.TK2MSFTNGP11.phx.gbl>
>
>
>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
>