Dear All,

Does anyone has a database benchmark result between ASA 7
with other desktop database such as Ms access, Paradox ..
etc..

Regards
Winanjaya

Winanjaya wrote:
No, and if they did they likely are not legally allowed to discuss them.
Most database vendors have licenses which explicitly disallow the
publication of performance numbers of their products, and arguably for
good reason.

The problem is over the definition of what constitutes a good "benchmark":
- how complex should the schema be?
- how big the database?
- how complex the query?
- which versions/builds of which RDBMS?
- which OS/version/build?
- how much memory?
- how much configuration is to be done to the RDBMS?
- how proficient is the person configuring the RDBMS?
- etc...
- etc...
- etc...

If you search this newsgroup for "benchmark comparison other" then
you'll find that....


Hey, you (or someone else posting as "Winanjaya") posted this exact same
question just over a year ago:

http://tinyurl.com/kxtsf [shortcut to Google Groups]

The 26-post thread is a great read...


The *big* question I have for you is why you are looking at ASA 7.x if
you are trying to make a decision about databases based on performance.
7.x is no longer under active engineering support. ASA 9.x has been
out for more than two years and version 10 is going into beta. There is
more than 5 years of (major!) performance improvements since v7.


LOL ... re-reading the thread I posted above, *all* of the points I want
to talk about have been discussed by lots of very knowledgable people of
whom only one is an iAnywhere/Sybase employee; the rest are application
developers like yourself who have come to recognize that SQLAnywhere is
the right tool for the situation you described (a year ago).

Please re-read the thread in its entirety. There is a *lot* of good
information in there.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Winanjaya, I don't have any specific benchmark results, but I tested SQL
Anywhere against Paradox a couple years ago. (I'm not sure of the version
numbers.) Paradox was very fast in querying a single table, especially if it
was on the local hard drive. SQL Anywhere, though, was *much* faster than
Paradox when a query was complex or involved joined tables, i.e. when the
database was used in a relational way and not just as a flat file. I'm
talking about an order-of-magnitude difference in speed on some queries.

Also, I can get results with one query in SQL Anywhere, using its rich SQL
dialect, that require a script with several queries and/or procedural
commands in Paradox.

Finally, I've had table corruption and locking problems in Paradox that I
never encountered in SQL Anywhere. (And Access is reportedly weaker than
Paradox on a network; see the newsgroups for those products and compare for
yourself.) If users on a network connect to your database, you should use a
client-server database such as SQL Anywhere and not a desktop database such
as Paradox or Access.

Richard


<Winanjaya> wrote

Thanks a lot for your explaination, could you please inform
me where can I find the list of comparison between ASA 7, 8,
9, 10 (beta)?

many thanks in advance

Regards
Winanjaya

The documentation for the latest version includes changes from previous
versions. See this page:

http://www.ianywhere.com/developer/p...n9/dbwnen9.htm

Richard


<Winanjaya> wrote