Those numbers are easily handled by both databases using commodity
hardware, real or virtual.
Choose postgresql, it's good choice since it has support for geo spatial
data management, while IMHO there is no reason to use mysql.
mic
2014-10-06 6:30 GMT+02:00 arutti <andre.ru...@gmail.com>:
> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
