Hi All,

    Somehow  "original author" missed one INTETER column as searchable
field ( like unique or primary key) in the table. When execute queries
based on this integer field in where clause/joins, huge performance hit.
So, I am planning to add INDEXING for this integer column.

    Is there any alternative/best solution?

   Thanks in advance.

Regards,
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to