I am having many problems to delete a table with only 19000 rows.
The selection takes less than 1 second but on delete I wait more than 4 minutes and notthing. Can someone tell me what could happen ?
I tryed only one transaction but it does not work too:
BEGIN WORK;
delete from base.ticket where session_id = 17 and cash_id = 99 and promo_id = 5;
COMMIT WORK;
I just think it could be occuring becouse of many constraints (7 at all)
Please any help is welcomed.
Regards
Ezequias
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
