I have a geolocalisation application with 2 tables of interest i.e.
db.define_table('device', notnull=True, ...)
db.define_table('wp', 'device', type=reference device, notnull=True, ...)
The 'device' table may have several hundreds entries, while the 'wp' table
holding GPS-coordinates may have tousands of entries.
The 'wp' table is populated by requests from devices in the field and
queried by a smartphone application. JSON is used in both cases.
I have a choice of using MySql or PostgreSQL.
Is one of these DB best suited for this kind of load (many single entry to
one table) ?
Thanks for any advice.
Regards
Andre
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
