Re: issue with AutoInc field and locks

How to declare the field in the database when using a GUID?

"Vitali Kalinin" <vitkalinin@xxxxxxxxx> wrote in message
news:47a04ba4@xxxxxxxxxxxxxxxxxxxxxxxxx
1.. If it is possible try to avoid sequence autoinc in new developments,
since if some day you will decide to go 3 tiers disconnected mode it would
be general PITA. Use GUIDs instead, since they could be easily generated
on a client side
2.. I think that you can achieve exactly same effect if you will assign
Conection IsolationLevel to ilRepeatableRead and do select inside
transaction. But I should warn you that such design, i.e. usage of server
side cursors very badly affects performance in multi user environment.
Could you please elaborate what you are actually trying to achieve?
Definitely there should be better way.




.

Relevant Pages

  • RE: custom insert for databound datagridview
    ... generated" controls, forms and datasets, how do I hook into when SQL ... I am writing a desktop database application. ... I then created a new data source and pointed it to my desktop SQLCE database. ... The first field is a Guid. ...
    (microsoft.public.sqlserver.ce)
  • Multi-Select Boxes and Subform Help
    ... The database design is slightly ugly, ... Employee_ID as PK (GUID) ... tblClientSessions ... and will let the user select a client and move ...
    (microsoft.public.access.forms)
  • Re: custom insert for databound datagridview
    ... You might look at the current changed event handler for the binding source that is bound to the DataGridView. ... I am writing a desktop database application. ... I then created a new data source and pointed it to my desktop SQLCE database. ... The first field is a Guid. ...
    (microsoft.public.sqlserver.ce)
  • RE: custom insert for databound datagridview
    ... I am writing a desktop database application. ... I then created a new data source and pointed it to my desktop SQLCE database. ... The first field is a Guid. ...
    (microsoft.public.sqlserver.ce)
  • Re: Why is this idea bad?
    ... > This idea seems too much of a magic bullet for the re-postback problem, ... multiply that by a few users and your database will be underload ... > then store that guid in a database I could check on the postback to see if ...
    (microsoft.public.dotnet.framework.aspnet)