Re: too many files....

Dances With Crows wrote:
On Fri, 21 Jul 2006 16:22:14 -0700, CptDondo staggered into the Black
Sun and said:

I assume that I could do some sort of SQL magic to optimize the
indexes to make retrieval faster....

This depends greatly on which database you're using. Are you using My,
Postgres, Firebird, DB2, or something else? Anyway, HTH,

To an extent, yes..my limited experience suggests that although SOME databases do intelligent self indexing, most do none, or very primitive forms.

There is nearly always SOME gain - often substantial - to be had by examining what types of searches are done and indexing appropriately.

And or redesigning the database..sometimes making it not truly relational..its a trade off between data duplication, data space, slowness on some queries versus speed on others..
.