> That's such a bad idea. Not only does max() need to scan the whole table to
> find the desired value (for each INSERT), you will also - sooner or later -
> get collisions. Never ever use such a function to create primary keys. It
> will lead to problems. Use generators - they are the only transaction-safe
> way to get unique IDs.
I will do this, I've just downloaded all available documents (not too
much unfortunately), and checked this generator-issue.
For single-user environment the above is working, however you are
right that max() will scan all values.
Imre
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
