>De: [EMAIL PROTECTED]
>Fecha: 27/05/2008 19:56
>
>It's not supposed to, according to 
>http://sqlite.org/lang_createtrigger.html . The syntax
>only allows select, insert, update and delete statements.
>
>What are you trying to achieve?

I need to handle tables with several million records, on realtime, from RAM.
One of the fields takes few values (say, company website id), but new ids are 
added from time to time.  I would prefer to dynamically create a set of tables 
when a new id shows up, for the improved locality of reference plus reduced 
overhead from the website id and its non-unique index.

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

Reply via email to