In article <[EMAIL PROTECTED]>, Emre Erdogan wrote:
> Hi...
>
> I want to say some words about the "Table Locking" problem.
>
> I had a problem something like this one, I find solution for this by locking
> only the item that will updated. I added two areas one that has a value 0 or
> 1 giving it
Hi...
I want to say some words about the "Table Locking" problem.
I had a problem something like this one, I find solution for this by locking
only the item that will updated. I added two areas one that has a value 0 or
1 giving it is currently used by someone, and second time it is started to
us
Hello Rosen,
Lets say you are working against mysql...
2000 records in table 1 and 500.000 records in table 2 is few
information... and it's working 'cause you don't have 5
records in table 1 and 3.000.000 records in table 2.
But, I personally advise you to listen what Pete
Yes, it will be better, but this way it's impossible, because this is a
existing database with more than 2000 records in table 1 and 500 000 records
in table 2 - and I should change logic of all software for this.
I have an idea to try something - whould be working ? :
I want to create some fictiv
"Rosen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I have an orders with one main record in table1 ( client, date, e.t.c. )
and
> detail description in table2 ( all materials with quant, price, e.t.c. )
> and I save data in table1 for positions (range of id - autoinc field of
In article <[EMAIL PROTECTED]>, Rosen wrote:
> I have an orders with one main record in table1 ( client, date, e.t.c. ) and
> detail description in table2 ( all materials with quant, price, e.t.c. )
> and I save data in table1 for positions (range of id - autoinc field of
> records in table2) for
I have an orders with one main record in table1 ( client, date, e.t.c. ) and
detail description in table2 ( all materials with quant, price, e.t.c. )
and I save data in table1 for positions (range of id - autoinc field of
records in table2) for detailed data of order . And I don't want someone
el
Rosen wrote:
I need to be sure, thath nobody else will can write on some tables until I
don't append obout 4-500 records in these tables.
But until now I never used table locking in MySQL and I didn't found
information about this ( like examples ).
You could try a multi insert syntax such as
INSERT
I need to be sure, thath nobody else will can write on some tables until I
don't append obout 4-500 records in these tables.
But until now I never used table locking in MySQL and I didn't found
information about this ( like examples ).
Is there a problem with locking if PHP uses same user&pass for
Yes .. it is ok - the data that I allow to get updated like this is not that important
and when a update is made it
would be two people entering the same data anyways.
It is just for contact info for people in the db ... like there current phone or
address if it changes.
Michael.
On Fri, 9 J
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Michael Gale wrote:
> > For the UPDATES ... what would have it in theory two people hit the
UPDATE
> > button at the exact same time ? Would one just over write the other ...
> > cause that is fine ?
Hi Michael,
is it
Michael Gale wrote:
For the UPDATES ... what would have it in theory two people hit the UPDATE
button at the exact same time ? Would one just over write the other ...
cause that is fine ?
Whatever UPDATE gets there first will execute and the other one will
wait until it's finished to update. Ther
Hello,
I have a web app that uses a mysql database, now lots of INSETS and
UPDATES are done on a daily bases. Now I do not want to start locking
tables. For the INSERTS it is just a plain insert with a auto incrementing
primary key. So I am sure that multiple inserts would not have a problem is
m
Rosen wrote:
And if I perform "LOCK tables ..." nobody can;t write on these tables,
until I don't perform "UNLOCK TABLES" ?
If something happens ( I mean if some my queryes fails) ?
I have a feeling it would be very very good if you'd state why you feel
you need to LOCK these tables. There are g
And if I perform "LOCK tables ..." nobody can;t write on these tables,
until I don't perform "UNLOCK TABLES" ?
If something happens ( I mean if some my queryes fails) ?
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Friday 09 July 2004 07:24, Rosen wrote:
> > Thank
On Friday 09 July 2004 07:24, Rosen wrote:
> Thanks, but can you give me a sample PHP script with MySQL database, whitch
> do this?
Don't have any examples handy. Basically instead of performing your usual
single query, you sandwich it between two extra queries:
LOCK tables ...
your usual qu
Thanks, but can you give me a sample PHP script with MySQL database, whitch
do this?
Thanks
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Friday 09 July 2004 07:09, Rosen wrote:
> > Is thath mean, thath, when one user is addind records to table, and lock
> > it - w
On Friday 09 July 2004 07:09, Rosen wrote:
> Is thath mean, thath, when one user is addind records to table, and lock
> it - when another user is trying to get the max field value for some field,
> the script will waiting the first user to unlock table and then to see the
> max value of some field
Is thath mean, thath, when one user is addind records to table, and lock
it - when another user is trying to get the max field value for some field,
the script will waiting the first user to unlock table and then to see the
max value of some field in a table ?
"John W. Holmes" <[EMAIL PROTECTED]>
Rosen wrote:
I have the following situation: I have to prevent users to write at the same
time in one table in PHP script.
Is there a way the PHP to "understand", thath another user is filling table,
and to wait before begin to fill data?
Most databases have a LOCK command that you can issue. The o
Hi,
I have the following situation: I have to prevent users to write at the same
time in one table in PHP script.
Is there a way the PHP to "understand", thath another user is filling table,
and to wait before begin to fill data?
Thanks in advance!
--
PHP Database Mailing List (http://www.php.n
thanks again for the help. I'll be able to fix this app and will
incorporate your suggestions into my work in the future.
Chuck
> -Original Message-
> From: John W. Holmes [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 20, 2003 11:32 AM
> To: Mayo, Chuck
> Cc:
Mayo, Chuck wrote:
Hi all,
Hope you'll forgive the duplicate post but the list seems to be hopping
today (unlike the friday afternoon I sent the original query)... since
everyone seems to be awake today I thought I'd try it again:
Sorry about that; I hate to keep my employers waiting. BTW, I have
Hi all,
Hope you'll forgive the duplicate post but the list seems to be hopping
today (unlike the friday afternoon I sent the original query)... since
everyone seems to be awake today I thought I'd try it again:
---
I'm working through an issue that I'm sure everyone else has al
Hi all,
I'm working through an issue that I'm sure everyone else has already figured
out, how to lock a table during a series of INSERTS to prevent duplicate
entries:
The scenario is this:
OS Solaris 8
PHP 4.2.3
MySQL 3.23.53
Table type: MyISAM
1) A user submits a form containing about a
(PHP-DB folks, ignore this top question - unless you want to answer)
Which type of DB/Table provides table locking while a process is
altering data? I don't care for locking while using SELECTs, but I do
need locking when something's being INSERTed or UPDATEd, so I won't get
two process
26 matches
Mail list logo
