[edit]
Was i right in reading in that you felt just accessing the large hashtable was slow? or was the only real problem during the saving it?
both accessing (lots of $hfind().data) and saving are slow. I'd like to optimize parts of my script that take a while because then my script has to play catch-up (a lot can happen in 6 seconds). So anything that has to periodically scan the table is unacceptable. But I'll look into doing that either in the beginning or at the end.
I'll also look into splitting up the database into a main table (item = nick!ident@address%network), and a date lookup table (item = ctime, data = nick!ident@address%network).
@LethPhaos - I haven't seriously scripted anything in mIRC in a couple years, I didn't know there was a mysql.dll. I'll definately have to look into that.
