PERFORMANCE QUESTION

  • Thread starter Thread starter Savas Ates
  • Start date Start date
S

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?
 
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
 
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.
 
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,

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]"
in said:
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
Click to expand...

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