Hi, Am 01.07.2008 um 18:28 schrieb Mike Schrag:
cool, great to read that (and thanks for the correction :-D). In fact I switched from MySQL to Postgres last year and with MySQL it is definitely an issue. Especially if you want to use InnoDB tables. Full text indexing is not available then.But why are you using TEXT types for small text fields like firstname. Correct me if I'm wrong but I assume that you have much more performance and indexing power if you use varchar instead.from pg manual: "Tip: There are no performance differences between these three types, apart from the increased storage size when using the blank-padded type. While character(n) has performance advantages in some other database systems, it has no such advantages in PostgreSQL. In most situations text or character varying should be used instead."
Regards, Helmut
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
