MySQL INSERT - When to Use HIGH_PRIORITY with Webpage

This is a discussion on MySQL INSERT - When to Use HIGH_PRIORITY with Webpage within the PHP General forums, part of the PHP Programming Forums category; I've been having some problems inserting records into a mysql db - through a php page. According to php - the ...


Go Back   Usenet Forums > PHP Programming Forums > PHP General

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 12-01-2005
ManinBlaq
 
Posts: n/a
Default MySQL INSERT - When to Use HIGH_PRIORITY with Webpage

I've been having some problems inserting records into a mysql db -
through a php page.

According to php - the insert statement was correct, and everything was
working - ( mysql_query was returning true, and mysql_error() wasn't
returning any information). However, the new record was never posted
in the database -- and mysql_affected_rows() was returning that '0'
rows were affected.

Changing the INSERT statement to HIGH_PRIORITY seemed to fix this - in
that my record was finally added to the DB -- but, reading the mysql
documentation -- it doesn't seem like I should be using high_priority.

Basically, the documentation states that using HIGH_PRIORITY " also
causes concurrent inserts not to be used." .. isn't this kinda bad for
a website? I mean, feasibly I could have several people all hitting it
at the same time .. I can't have them ignored.

What's the proper mechanism I should be using? Should I be Locking /
Unlocking the table between inserts? Couldn't that also adversly
affect my users?

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:44 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0