Backend performance 2000 vs 2007

  • Thread starter Thread starter TonyT
  • Start date Start date
T

TonyT

Hi,
My current application is all A2k, but I'm doing a major re-release as an
mde in 2007 for the front end. The Backend will undergo major changes too,
but ideally I'd like to stick with 2000 so as not to force my customers to
have to purchase an upgrade.

Would I notice a real life performance gain using 2007 as opposed to 2000
purely in backend performance? Current fe version is about 60 forms, 60
queries with the be having about 40 tables with up to perhaps 200,000 records
in the most populus and an average of maybe 12 fields per table. Average of 4
concurrent PC's accessing over 100Mbit lans.

Once I have the front end up and running I make look to go to an SQL
backend, but my customers are very low tech and ummm cost conscious.

Any comments greatly received.
 
Personally I wouldn't worry about it much. There's some MVPs here that still
use 97, let alone 2007. '07 is nice if your customer wants to feel like
they've got the latest and greatest, but as you say, 2000 is nice because
some customers don't like to spent the upgrade money. I tend to use 2003 for
everything as my base (which is in 2000 format), and while I've never tested
it, I've never heard much about any noticeable performance increases with 07.

From what I gather, the only major changes to '07 (other the the obvious
interface adjustments) is the addition of multi-value fields (which defies
the Normalization rules, IMO... I've never used MVFs, but search on First,
Second and Third Normal Forms if you want to see the contradiction ("...Every
row-and-column intersection contains exactly one value from the applicable
domain (and nothing else)."), and a few functions being added/removed.

So I'm probably not fully qualified to answer your question, but that's my
thoughts on it... I don't think that '07 offers any significant real-world
advantages over other versions, let alone huge performance increases
(although a jump to SQL Server would do that if you end up having lots more
records than you currently do).

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
thanks for the response both of you.

Only reason for me upgrading to 2007 is for the new front end features and
improved look over 2000. Originally I didn't provide and mde as when ak first
came out when I developed the original version the developer edition was very
expensive and I knew that I would be developing the product rapidly with my
customers and preferred the idea of being able to do it real time with their
data as an mdb.
 
Back
Top