That's why I'd second the Interbase recommendation

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #20,101

by tseliot

12/3/01 3:28:05 PM

That's why I'd second the Interbase recommendation

I don't think you need to split your research time any further. IMO your free options should be Postgres vs Interbase. MySQL has too many issues like this; cf. wharris' mention of accuracy (below) and the locking issues (although your description of essentially read-only ameliorates that one somewhat). But these are symptomatic of the many design trade-offs that were made all in the name of speed and small footprint. Comparing Oracle and MySQL is, IMO, an apples-and-oranges comparison. IB, on the other hand, is much closer to Oracle functionality and design.

---------------------------------
A stupid despot may constrain his slaves with iron chains; but a true politician binds them even more strongly by the chain of their own ideas;...despair and time eat away the bonds of iron and steel, but they are powerless against the habitual union of ideas, they can only tighten it still more; and on the soft fibres of the brain is founded the unshakable base of the soundest of Empires."

Jacques Servan, 1767

MySQL vs Oracle question - (broomberg) - (23) - Dec. 2, 2001, 09:37:16 AM EST

Other things to consider: - (admin) - (14) - Dec. 2, 2001, 11:45:06 AM EST

Re: Other things to consider: - (broomberg) - (6) - Dec. 2, 2001, 12:08:04 PM EST

Interbase "seen" as going away... - (admin) - (5) - Dec. 2, 2001, 03:34:21 PM EST

Re: Interbase "seen" as going away... - (broomberg) - Dec. 2, 2001, 07:41:07 PM EST

PostGreSQL setup/complexity - (broomberg) - (3) - Dec. 3, 2001, 08:18:29 PM EST

Yep. - (admin) - (2) - Dec. 3, 2001, 08:58:00 PM EST

Re: Yep. - (broomberg) - (1) - Dec. 3, 2001, 09:42:28 PM EST

Shouldn't need one right away. - (admin) - Dec. 3, 2001, 11:07:27 PM EST

Wierd create index behaviour - (broomberg) - (6) - Dec. 2, 2001, 12:36:13 PM EST

index create - (boxley) - (5) - Dec. 2, 2001, 08:04:05 PM EST

Re: index create - (broomberg) - (4) - Dec. 2, 2001, 09:09:04 PM EST

Well, Sybase still has some money - (tonytib) - Dec. 2, 2001, 09:39:52 PM EST

Re: index create - (broomberg) - (2) - Dec. 2, 2001, 10:27:47 PM EST

1.5 hours to create index - (broomberg) - Dec. 2, 2001, 10:53:57 PM EST

That's why I'd second the Interbase recommendation - (tseliot) - Dec. 3, 2001, 03:28:05 PM EST

Re: MySQL vs Oracle question - (wharris2) - (2) - Dec. 3, 2001, 12:47:34 AM EST

Readonly - (broomberg) - (1) - Dec. 3, 2001, 07:09:48 AM EST

Readonly? Hell, then, full speed ahead! -NT - (wharris2) - Dec. 6, 2001, 07:41:13 PM EST

14 hours later, still indexing - (broomberg) - (2) - Dec. 3, 2001, 02:08:57 PM EST

20 hours later, still indexing - (broomberg) - (1) - Dec. 3, 2001, 08:15:59 PM EST

Wheeee - Done!!! - (broomberg) - Dec. 3, 2001, 11:03:46 PM EST

New design - (broomberg) - (1) - Dec. 5, 2001, 08:58:34 PM EST

Happy Ending! - (Meerkat) - Dec. 6, 2001, 06:01:45 PM EST

iwethey.org

If your role can be replaced by Keanu Reeves miming walking into a non-existent wall, then you probably need to go back to waiting tables at the Ground Round--make that the homeless shelter.
91 ms