Hollowshade Moore watch

[GeorgeS]

Part of the problem was asignment of very high id's in tables when inserting records. I'm pretty sure MySQL does a Select MAX(field)+1 when running an insert query, thus a table like spawngroup has very high spawngroup.id's.
The highest one I have is '33,590,086'!. So a while ago I had considered a tool to 'pack the data', but realised some people had id's ranged in specific groups so they could identify npc's to zones etc.. This in effect killed the idea. Packing is not hard, but tricky because there are many possibilities of breaking tables irrevocably. I can write a tool to 'pack' specific tables, but then it may never get used.

GeorgeS

[John Adams]

I wish I could find the old debates between Angelox and myself about index IDs. Just once I'd like him to acknowledge "John Adams was right a year ago". But that'll never happen.

I'm still happy.

[Angelox]

Originally Posted by John Adams

I wish I could find the old debates between Angelox and myself about index IDs. Just once I'd like him to acknowledge "John Adams was right a year ago". But that'll never happen.

I'm still happy.

You mean this?
http://www.eqemulator.net/forums/sho...455#post125455
or this?
http://www.eqemulator.net/forums/sho...462#post125462