As continuation to my last question, I got another one. a brief summary: I had to process a file that contains 700,000 lines, each line contained some data (lets assume each line was like: name|age|work|lastaccessed ) age contains the person's age in time() format, how many seconds has past since he was born. lastaccessed contains also a time(), with his last access. work is some text, also is name. ) so I inserted it (with stacked queries), My question is - lets assume I get a new file, and I need to compare the changes - how would you suggest me to do it? Assuming that if the new file has more lines I should insert (and of course know about it so I can notify the user), and assuming the new file has less lines - I should delete (and of course know about it so I can notify the user). I also don't have the old file. I have no idea that is fast enough (less then 30 minutes. Insertion took about 10 minutes). What's your idea? -- Use ROT26 for best security
