[Tutor] what are some alternatives to XMLRPC?

R. Alan Monroe amonroe at columbus.rr.com
Mon Sep 15 22:00:06 EDT 2003


I ran some tests this evening with XMLRPC, and found it to be a little
too slow for my needs...


Pulling 85000+ records from a database using XMLRPC:

C:\coding\python>python addemcli.py
33.9689999819 seconds

Same query, but just a direct connect to the database:

C:\coding\python>python dbtest.py
1.13200008869 seconds

The database is sqlite, using the sample data from
http://pysqlite.sourceforge.net/examples/itis/

The query was "select * from geographic_div"

Apart from the speed concerns I also ran into some other problems with
unparseable data when selecting from other tables
(xml.parsers.expat.ExpatError: not well-formed (invalid token): line
37018, column 27)

Can anyone suggest some faster alternatives? I'm trying to make a bare
bones 3 tier environment where a client makes an API call to an app
server via XMLRPC, the app server gets data from a database and sends
it back to the client.

Alan




More information about the Tutor mailing list