views:

46

answers:

2

Hi,i got an assignment to make something similar to http://typewith.me .The problem i am facing is that i have to send xml through AJAX from one user to server(im using PHP) and the other user will receive it when he makes request through AJAX. But storing XML in database in the intermediate time will make it slow. So where else can i store the XML. Remember there can be multiple users and it all should be synchronized. Please Help.

Thanks.

+1  A: 

But storing XML in database in the intermediate time will make it slow.

No, it won't. This is what databases are for - storing data for later retrieval.

TypeWith.me uses EtherPad, which uses the MySQL database as a backend.

ceejayoz
Thanks alot. Ill then stick to MySQL and see how it performs.
zabi
+1  A: 

As far as I can read from the Etherpad documentation, which is the engine used by typewith.me, it uses Apache Derby as a database. In this Etherpad fork, the author suggests to use more powerful databases - such as MySQL - when the number of users exceeds 100.

To be honest, I would strongly suggest you to use a Database. You can still profile your web application, trying to identify and optimize your bottlenecks if the case.

Roberto Aloi
Etherpad's [requirements](http://code.google.com/p/etherpad/wiki/Instructions) list MySQL.
ceejayoz