Subject New to SQL / Interbase
Author Michael Melling
I am a relative novice when it comes to database design and
management. I work for a company of 15-20 people, which uses a
Novell NetWare 5 network and relies heavily on our in-house
Paradox 7 database. Over the past two years I have become
increasingly involved in firstly, running queries and reports, and
more recently maintaining and developing our database. We are
considering upgrading to a client/server SQL database - something
which has been at the back of the mind of the director, who
our database from scratch, for some time, but which he has not been
able to invest any time in, so has been put off. We have a 60-day
trial version of Interbase 5.6 for NetWare, which I am trialing: Does
anyone know if/when Interbase 6.0 OpenSource is being launched

I have read 'Upsizing Paradox Databases to Interbase' by James
Arias-La Rheir on the Interbase website, which is reassuring that we
are on the right track, as we are planning to continue using our
existing Paradox forms as an interim measure. Are then any other
introductions to interbase-conversion that I should read.
Incidentally, I was checking out the Interbase site to find an article
on the EMPLOYEE example database referred to in the manual, but
to find this - anyone know where this is located.

I have a few initial random queries:

Which network protocol is most succesful in why situation: IPX/SPX

Which type of driver should I use as a BDE alias - the Borland
native SQL Links driver or an ODBC driver (I have a choice between
Intersolv Interbase ODBC Driver and InterBase 5.x Driver by

I have been told that SQL databases do not cope well with tabular
views on the user interface. I tested this by creating an Interbase
database with a table containg three short columns and about 40,000
rows, which comprise the main body of our people-based database.
then created a form which displayed this in Paradox. Initially,
scrolling through caused an error, which I fixed by creating a temp
directory on the SYS: volume where Interbase was installed on the
server - persumably Interbase performs some type of file caching.
Scrolling down then worked, but the server utilisation shot up to
100%. This also occured when I moved to the last record and when
changed my form to show just one record at a time. Admittedly, I am
using our old server, which has a 233MHz processor. However,
when we
ran our network from it, we would normally regard 15% as at the high
end of normal and 50% as virtually network-crippling. I am
that our GUI uses a lot of tabular-type views and scrolling down an
indexed list of records to select the correct one is a fundamental
design feature: what would happen when we have 15 users using the
Interbase database, even on our new high-spec server. Am I
something fundamental about SQL databases and the way to access
information here, or is a hardware limitation? What would you
as the minimum hardware spec for a server? Should I expect
to run noticably slower than our Paradox file-based structure?

I would be grateful for any responses/comments to any of these
queries and your patience with a beginner. Please let me know if I
addressing these issues to the wrong newsgroup and suggest

Michael Melling
+44 (0)20 7375 3211

This email, and any attachments it may contain, is confidential
and is intended only for the person(s) to whom it is addressed.
If you are not the intended recipient please delete this email,
and do not disclose its contents or re-transmit it to others.