*** 682,687 **** --- 682,693 ---- *: As to the above - those numbers and the queries are meaningless without the database schema and the source used to conduct the test. If you'd like to lend some credibility to your assertions, you need to provide a link where that information can be downloaded or viewed. + *: (1) About the 'speed results'. Speed?, are you talking about speed?, ouch. I can give you the fastest queries on Oracle with 'FIRST_ROWS' hints, i can tweak to the death some internal parameters to give users their results on a fraction of a second, heck, i can even cheat with my indexes to achieve this results ... but know what?: these results don't mean anything. Like yours. What kind of value has a querie that executes on 2 seconds and uses 50% of CPU if another one do it on 10 seconds and uses only 10% of CPU?. Do you know how to answer to this question?. Easy: it depends. Always depends. C,mon man, don't pretend to be a Lord Sith on the first day, complete your Padawan lessons before ;). + + *: (1, continued) How many parses and fetches are generating your queries on your Database?, what kind of 'stress' level are suffering your disks?, and your CPU?, what about the locks?, and the waits?, are you doing 'implicit conversions' of the SQLite side?, are you using the same amount and cardinality of data on SQLite?, are you using some kind of index on SQLite?, do you know how to create indexes on SQLite?, WHY are you querying against a table and not against a view?, do you know something about views and database schemas?, do you have the ER diagram of both schemas in order to have 'something' to show us?, do you have REAL benchmarks that we could tests on our environments? ... etc. + + *: (1, continued) HOW COULD YOU (sorry for the caps) guide me to the 'users testimonials page' in order to check real data load (on the 'wide' meaning) on production environments?. Are you kidding me?. Oh, god!. This is like "hey, i would like to know how your Database behaves on a 3000 concurrent users environment with 2000 transactions per second. I am mainly interested on the cluster solution that you could give me and the efficient ways to maximize CPU, RAM and HD resources" and your answer being "yeah, go to www.nice-database.com/testimonials.htm and read my happy-customers histories". LOL. Are you serious?. + I wonder how useful these "remarks" are... What about Apache Derby? It uses the Apache 2.0 license and is easy to embed in Java applications
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|