Before you switch, you can get Access to perform decently. Have you been
shrinking the database? Are your indexes well planned?
Unless it would be a big deal (rewrite of existing applications) I would
look at a mild migration to mySQL (it has ODBC drivers) or PostgresSQL (sp?)
as well.
David L. Penton, MCP
Consultant
"Mathematics is music for the mind, and Music is Mathematics for the
Soul. - J.S. Bach"
[EMAIL PROTECTED]
"Are you patched for CodeRed? If not, why not?"
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/
bulletin/MS01-033.asp
-----Original Message-----
From: Brian Thomas
Hi everyone,
We are in the early stages of looking for an upgrade to our
current Access database. Yes, I know. Access is slow. We only handle a
small amount of data, but performance is becoming a problem. Some of our
tables have 15,000 records, but that is the largest so far. We are
anticipating breaking 30,000 records per table soon though.
My question is, for a 2-person IS department at a very small
company, should we upgrade to SQL? Is there another database short of
Oracle (remember, only 2 people) that would require less setup? I am
also concerned about migration. If I set up new datasources in CF, could
I copy my macros into SQL? Or, would I be better pursuing another route?
I know everyone has a favorite database, so please let me know
the pros and cons.
Thanks,
Brian Thomas
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
