|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
PERFORMANCE QUESTIONI 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 Show quoteHide quote "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. Show quoteHide quote "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 Show quoteHide quote "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 Show quoteHide quote "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]"
<notmyfirstn***@planet.nl> wrote: in <Okh2caCVGHA.5***@TK2MSFTNGP11.phx.gbl> >Savas, Well, good that we cleared that one up a bit.> >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 > --- This posting is provided "AS IS" with no warranties, no guarantees, and no conferred rights. Stefan Berglund Yep, clear as mud (as Cor's posts usually are, from memory).
Show quoteHide quote >On Thu, 30 Mar 2006 20:22:04 +0200, "Cor Ligthert [MVP]" ><notmyfirstn***@planet.nl> wrote: > in <Okh2caCVGHA.5***@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 > > 
Thread options
Other interesting topics
Returning complex calculation as column?
Framework Equivalent in MSSQL? I don't want user dynamic sql creating sp to export column to comma delimited list Is there an easier way to do multiple aggregate columns in tsql Stuck on Query Simple query but no results... conditional WHERE clause Store big binary files in SQLserver 05 vachar(max) column Combine multiple lines for one record into one comma-delimted field |
|||||||||||||||||||||||
