I had been working on "Preorder tree traversal algorithm" as a part of my daily task. What I came across was that for MySQL, we need to lock a table and after insertion or deletion of any entry, we need to unlock the particular table (I succeeded in my task though).... I just wonder why we do this? Apart from this case, where else do you think this can be used in case its frequently in use ?
-
I hope I am clear enoughSachindra– Sachindra2010-01-08 14:26:53 +00:00Commented Jan 8, 2010 at 14:26
-
1To be honest, you could be clearer by properly spelling words like "juz", starting your sentences with a capital letter, and ending your sentences with a single period or question mark.Bart Kiers– Bart Kiers2010-01-08 15:26:27 +00:00Commented Jan 8, 2010 at 15:26
-
ok Bart, I will definitely make things clearer the next time onwards.Sachindra– Sachindra2010-01-09 04:30:51 +00:00Commented Jan 9, 2010 at 4:30
Add a comment
|
1 Answer
You need to lock a table if you don't want its contents to change while you are doing whatever you are.
So in your case, I assume that you would not want the table to change while you do your traversal (I assume your table data forms some sort of tree).
So one option you have is: LOCK the table, COPY its contents to another table, UNLOCK it, and operate on the copy.
If your original table is small enough, you can even make your temp table in-memory.
Beware: locking tables can cause other scripts that use the table to wait! Be sure that your operations will not take a lot of time.
