>
> TANSTAAFL.
????
>
> Indexing adds overhead, slowing down inserts/updates/deletes, and, if
> you care anything about ACID, causes locking.
I guess this depends on the Db size etc....other factors But to me it
is a small price to pay.
I had a MySql table with about 1.5 million records without any index.
Queries to this table took easily 4-20 seconds..... By adding index to
one field, the query times went down to 0.00....something seconds.
(can't remember now was it milli or micro, and too lazy to look it up....)
>
> Also, there are (at least in the RDBMS that we use) two kinds of
> indexes, hashed and b-tree, which are targeted at significantly
> different work flow.
Yet another field I know nothing really..... I only use Mysql, MyIsam
and InnoDb engines..... I have recently started considering the NDB
engines too..... just have to make more studying about whether or not
it works for me as praised on the web.....
Petri
___________________
Nolug mailing list
nolug@nolug.org
Received on 12/07/08
This archive was generated by hypermail 2.2.0 : 12/19/08 EST