Optimize in what way exactly ?

I have well over 1 million records and its fine for me since all database calls use indexes.

Seconded. I didn't see a reply to this in this thread.

What exatly is a "template hook," and where do I put it? I gather that it's the "showthread" template, but where do I go to change that?

Pardon my ignorance. This is my first trip around the block with vB hacks and such, so I'm trying to learn as quickly as possible.

Thanks.

Hello Paul M

Something wrong with my index

KEY `readtime` (`dateline`)
I don't know how this value come from.

I changed to
KEY dateline (threadid,dateline)

now is working fast

Thank you.

Yep, you certainly need the dateline index defined, otherwise it would be deadly slow .....

I have no idea where that readtime definition came from, the proper definition has been the same in all versions (since it first got released for 3.5).

Thanks!

I have a problem with the time. I created a new thread at 2:58 am and when I see the "View-All" botton it show me at 14:58.
Any help about this?

Paul, we getting a vb4 version?

Maybe, if I can figure out how to display tabulated data in vb4.

If it helps, I know installing it to vb4 does not break the forums. It just doesn't display the information.

I know ;) I have a partially updated version from Alpha 3, not looked at it since.