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
