| Simple Insert issue |
[eluser]ericsodt[/eluser]
[quote author="Alex007" date="1190414310"]MySQL has a REPLACE keyword for that, but you can't use it in Active Record, you'll have to use SQL and $this->db->query(); http://dev.mysql.com/doc/refman/5.0/en/replace.html[/quote] That is a big help, only I am concerned because it would have to do 2n transactions. Meaning it would have to delete and then re-insert each time for EACH record. I have A LOT of transactions occuring and do not want to bog down the database. Thanks though! |
| Messages In This Thread |
|
Simple Insert issue - by El Forum - 09-21-2007, 08:35 AM
Simple Insert issue - by El Forum - 09-21-2007, 08:54 AM
Simple Insert issue - by El Forum - 09-21-2007, 08:57 AM
Simple Insert issue - by El Forum - 09-21-2007, 09:11 AM
Simple Insert issue - by El Forum - 09-21-2007, 09:43 AM
Simple Insert issue - by El Forum - 09-21-2007, 09:46 AM
Simple Insert issue - by El Forum - 09-21-2007, 09:53 AM
Simple Insert issue - by El Forum - 09-21-2007, 10:07 AM
Simple Insert issue - by El Forum - 09-21-2007, 10:08 AM
Simple Insert issue - by El Forum - 09-21-2007, 10:09 AM
Simple Insert issue - by El Forum - 09-21-2007, 10:11 AM
Simple Insert issue - by El Forum - 09-21-2007, 10:17 AM
Simple Insert issue - by El Forum - 09-21-2007, 11:38 AM
Simple Insert issue - by El Forum - 09-21-2007, 11:43 AM
Simple Insert issue - by El Forum - 09-21-2007, 11:48 AM
|
