[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