1) Is the efficiency (in terms of speed) of an index equal whether field is
INT/REAL/TEXT? (Where all data is of storage type INTEGER for INT field, REAL
for REAL, TEXT for TEXT)
I did some tests which showed that speed is equal. My real question is:
2) If an indexed field contains records with a mix of storage classes (e.g.
some records are stored as REAL, some as TEXT), does this decrease speed
performance of the index in any way?
Thanks
Rael
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
