Hi there,
May I ask, if you have a one-to-one relation of Books vs. Authors and wish to maintain it as such, why do you not just have one
table with both fields and appropriate indexes? Searches wouldn't really be much faster, but all this deletion maintenance would go
right down to near nothing.
On 2013/06/12 11:55, dd wrote:
Thanks for your response.
It will delete from Author_Books when book deleted.
I am trying minimize queries on Authors table. For every deletion of record
from Books, it needs to check in Authors table. One extra query execution
is there. I am trying minimize that.
On Wed, Jun 12, 2013 at 1:00 PM, Clemens Ladisch<clem...@ladisch.de> wrote:
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
