Database: INSERTS, speed and primary keys

[Monte Goulding]

> HI Monte - hows down-under :)

Getting better all the time ;-)
> 
> Only by making the primary key = "name,type,location,hnum" instead of "id"
> woudl you get a fast normalisation of the data inserted.

You can create an secondary key for those fields and still use your primary key auto-increment field for a foreign key in other tables.

Cheers

--
Monte Goulding
M E R Goulding Software Development
Bespoke application development for vertical markets

InstallGadget - How to create an installer in 10 seconds
revObjective  - Making behavior scripts behave