rudibrazil78 schrieb am 06.02.2013 um 14:31 (-0000):

> calls table have 130 fields, one PK, 60 FK's, about 20 extra indexes.
> clientes table have 186 fields, one PK, 45 FK's, about 20 extra indexes.

More than 60 indexes on one table … okay! :)

> For testing sake, I droped all indexes and fks on both big tables and
> things got much faster. I might consider this as a last resort
> solution tho.

One Java consultant here in Germany said in a training I attended that
in big financial systems FKs are usually turned off because otherwise
they wouldn't be able to handle their large import batches. I could
hardly believe it. I don't have any experience myself to corroborate
that statement.

Michael

PS and not specific to this topic:

I don't know what »User-Agent: eGroups-EW/0.82« is but it doesn't appear
to honor Internet Mail Message IDs, omitting the »References« header,
thus breaking threads, which negatively affects list readability.

Threading: Message-ID, References, In-Reply-To
http://cr.yp.to/immhf/thread.html