zaher dirkey wrote: > Thank for replay, i will use it, but that make the sql slow. >
Yes, it is slower than the insert that didn't work correctly. :-) To ensure optimal speed you should have an index for the subselect to use during its search. If the table has a primary key , that would be the item to match on. In your case, if the combination of Material and Name is a primary key, then it should be quite fast. If it's not, then making them a primary key, or adding an index on those columns will help. HTH Dennis Cote _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
