![]() Thanks in advance guys, the help is appreciated. If you need any more information just let me know I don't mind simple/incomplete answers if there are links to compliment. The EDB Postgres Platform is an enterprise-class data management platform based on the open source database PostgreSQL with flexible deployment options and Oracle compatibility features, complemented by tool kits for management, integration, and migration. I think that's already a lot to answer so I'll stop here. How do Oracle and PostgreSQL leverage multicore/cpu power (if/when we get an oracle license).How do oracle and postgreSQL leverage cache on subqueries, WITH, and UNION/INTERSECT statements.How would losing full text indexing impact performance in the three cases (does oracle or postgreSQL have an equivalent?). ![]() Adapt to Oracle XE and get a license when we need to scale upwards of 4Gb database, 1Gb RAM or the 1 CPU limit (all of which we haven't hit yet). The three options being considered are to either continue using mysql but with the INNODB engine, this way we can leverage more CPU power. For instance, using subqueries over multiple tables with millions of rows (even with decent indexing) turns out to be a big issue with the current/upcomming load and the constraint layed out in the point above (CPU usage)įeeling the need to scale up in the upcomming year, but not necessarily ready to pay for licensing right away, I've been thinking about rewriting the application and switching DBs. Thus multiplying the number of queries made.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |