Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Interbase compared with SQL Anywhere

0 views
Skip to first unread message

Medisoft International Pty Ltd

unread,
Jun 6, 1998, 3:00:00 AM6/6/98
to

Has anyone else experience using both Interbase (5) and SQL Anywhere (5.0)?

We are finding some queries significantly slower with Interbase, which - as
Interbase uses a native driver rather than ODBC - is not what we were led
to expect.

--
Lesley McCrann
les...@medisoft.com.au
(Medisoft International)

KT95

unread,
Jun 6, 1998, 3:00:00 AM6/6/98
to

Are the tables indexed correctly (per the query)?????
--
Remove NOSPAM. from email

Medisoft International Pty Ltd <les...@medisoft.com.au> wrote in article
<01bd90ee$c85a01c0$7cc302cb@lesley>...

Flying Objects

unread,
Jun 6, 1998, 3:00:00 AM6/6/98
to

But ODBC _is_ the native driver for SQL Anywhere... As is increasingly the
case with many db's, e.g., Access and MS SQL Server they are built around
ODBC and so that is the best way to access them.

Medisoft International Pty Ltd wrote in message

Craig van Nieuwkerk

unread,
Jun 7, 1998, 3:00:00 AM6/7/98
to

The tables are indexed correctly. We have a SQL Anywhere database and a
functionally equivalant Interbase one. The same queries peform up to 15
times slower with Interbase than with SQL Anywhere. This is, same tables,
same structures, same indexes, Interbase is much slower.

Oliver Townshend

unread,
Jun 7, 1998, 3:00:00 AM6/7/98
to les...@medisoft.com.au

I am sure you will find that the two databases perform differently.
This is because Interbase is designed very differently from other
databases, so what works quickly in SQL-Anywhere may be slower in
Interbase, but the reverse may apply in other cases. If you join the
interbase mailing list (at www.mers.com) you may be able to ask specific
questions which may help speed up your queries.

To improve the performance of Interbase, you may wish to perform a
backup and then a restore. This certainly tidies up the database and
balances indexes.

I have found that SQL-Anywhere works quite well myself. I liked
Interbase, but since it didn't support currencies properly, I was forced
to drop it.

I wonder how fast your queries are when run using the ISQL of the
appropriate databases (i.e. without the bde in the way)?

--
Oliver
oli...@zip.com.au
Sashalom Pty Ltd
Ph: +61-2-9283-1377 (w) 9675-1769 (h) 0411 754 414 (mob)

Craig van Nieuwkerk

unread,
Jun 8, 1998, 3:00:00 AM6/8/98
to

Without the BDE using WISQL the queries have no recognisable performance
improvement.


0 new messages