Skip that, that is foreign-keys. What problem are you having with trigger performance?
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >[email protected]] On Behalf Of Keith Medcalf >Sent: Saturday, 9 June, 2018 22:06 >To: SQLite mailing list >Subject: Re: [sqlite] Idea: defining table-valued functions directly >in SQL > > >Do you have an appropriate index defined on both the parent and child >keys? > >.lint fkey-indexes > >at a command shell prompt will tell you ... > >--- >The fact that there's a Highway to Hell but only a Stairway to Heaven >says a lot about anticipated traffic volume. > > >>-----Original Message----- >>From: sqlite-users [mailto:sqlite-users- >>[email protected]] On Behalf Of David Burgess >>Sent: Saturday, 9 June, 2018 21:44 >>To: SQLite mailing list >>Subject: Re: [sqlite] Idea: defining table-valued functions directly >>in SQL >> >>> reminder that views can have triggers >> >>Anyone else have an issue with trigger performance in SQLite? >>_______________________________________________ >>sqlite-users mailing list >>[email protected] >>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
