How much data Access can handle?

[Vladimír Cvajniga]

Is MySQL a toy? I don't think so...
V.

Why a toy database like MySQL? Why not a real one, like SQL Server
or PostgreSQL?

 

[Tony Toews [MVP]]

It might be a good idea to re-evaluate the indexing, and remove
unnecessary indexes. If you've created relationships with other
tables, there may be hidden indexes (creating a relationship creates
a hidden index on the PK and FK in the tables in the relationship),
and you could then delete the non-hidden duplicate index.

I'm 99% sure that Access is smart enough that duplicate indexes use the same data.
There was a KB article mentioning a Jet bug where one field in an index was based on
descending and it was the same index as another one based on the same field that was
ascending.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[David W. Fenton]

I'm 99% sure that Access is smart enough that duplicate indexes
use the same data. There was a KB article mentioning a Jet bug
where one field in an index was based on descending and it was the
same index as another one based on the same field that was
ascending.

It didn't used to, back in Jet 3.5 days, because I reduced the size
of a replicated MDB by about 15% when I learned about hidden indexes
and removed the duplicates.

 

[David W. Fenton]

MySQL is free!!! MS SQL Server is not free, haven't heard of
PostgreSQL yet.

Free to acquire, but that's the least of the cost of any system like
a server database.

PostgreSQL is also an open source RDBMS, and free. And it's been
much better than MySQL for a very, very long time
(features/performance).

 

[David W. Fenton]

Is MySQL a toy? I don't think so...

It lacks features that Jet has had for 15 years. It's barely caught
up by the work of the InnoDB folks. It's great for websites, but
it's not really optimized for heavy-duty data processing.

The idea that it got RI only a few years ago is just ludicrous (and
still not available in MyISAM, so that you have to choose between RI
and, say, full-text indexing).

 

[Vladimír Cvajniga]

Thx a lot for the information, David. I think I'll have a look at
PostgreSQL.

Vlado.