[sqlite] Question on index efficiency

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@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users