On Thu, Mar 08, 2001 at 10:30:18PM -0500, Justin wrote:
>
> Typically, in a database backed website with a very high percentage
> of selects to inserts, people do not "expect" update operations
> (posts and so on) to complete very fast. But they do "expect" page
> requests to be very fast.. the d
thanks,
Then I imagine, as a rule, I should be thinking about changing
that server variable to set selects to always have priority?
Without transactions, one should never have a situation
where any ill effects can result from delaying "users" that
issue live insert or update requests until the p
Hi,
Imagine the scenario of the following happening in quick succession:
user1: select * from table --- ticks away, doing the select
user2: select * from table --- also ticks away
user3: insert into table ... --- locked!, waiting for selects
to finis
