Should I use locks?

[Laphan]

Hi All

I'm really going to show my naivety now, but should I be using locks where
possible when my ASP/MySQL DB site is posting data back to the DB?

I don't have that many sequential (shall we say) posts and for example, to
post an order into my DB it contains the header page data as 1 post and then
an INSERT INTO / SELECT FROM query to take the data out of one table and put
it into my ORDERLINES table shall we say?

I've just noticed that when I used a conversion util to convert my Access DB
data into a MySQL DB, above and below the list of many DDL inserts the DDL
script locks the table before doing these inserts and then unlocks it once
finished.

Is it common practise to do this?

Any pointers you can give would be appreciated.

Rgds

Laphan

[Bob Barrows [MVP]]

Laphan wrote:

> Hi All
>
> I'm really going to show my naivety now, but should I be using locks
> where possible when my ASP/MySQL DB site is posting data back to the
> DB?
>
> I don't have that many sequential (shall we say) posts and for
> example, to post an order into my DB it contains the header page data
> as 1 post and then an INSERT INTO / SELECT FROM query to take the
> data out of one table and put it into my ORDERLINES table shall we
> say?
>
> I've just noticed that when I used a conversion util to convert my
> Access DB data into a MySQL DB, above and below the list of many DDL
> inserts the DDL script locks the table before doing these inserts and
> then unlocks it once finished.
>

It is very rare that the programmer needs to override the locks that the
database engine is already placing on the database objects. It is best not
to interfere in the process unless one truly understands the ramifications
(which simply cannot be taught in an email message)

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Laphan]

Thanks Bob


Bob Barrows [MVP] <reb01501@NOyahoo.SPAMcom> wrote in message
news:#TImwywWEHA.3596@tk2msftngp13.phx.gbl...
Laphan wrote:

> Hi All
>
> I'm really going to show my naivety now, but should I be using locks
> where possible when my ASP/MySQL DB site is posting data back to the
> DB?
>
> I don't have that many sequential (shall we say) posts and for
> example, to post an order into my DB it contains the header page data
> as 1 post and then an INSERT INTO / SELECT FROM query to take the
> data out of one table and put it into my ORDERLINES table shall we
> say?
>
> I've just noticed that when I used a conversion util to convert my
> Access DB data into a MySQL DB, above and below the list of many DDL
> inserts the DDL script locks the table before doing these inserts and
> then unlocks it once finished.
>

It is very rare that the programmer needs to override the locks that the
database engine is already placing on the database objects. It is best not
to interfere in the process unless one truly understands the ramifications
(which simply cannot be taught in an email message)

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Bullschmidt]

Cursor & LockType Performance Report - 6/27/1999
[url]http://www.4guysfromrolla.com/webtech/062799-3.report.shtml[/url]

Cursor & LockType Performance Issues - 6/27/1999
[url]http://www.4guysfromrolla.com/webtech/062799-3.shtml[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
[url]http://www.Bullschmidt.com[/url]
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!