I have an extrememly query heavy site that I tried to switch from MySQL to
PgSQL. And after spending literally a week reconfiguring thousands of
queries and rewriting code, I finally had the pgSQL version of the site
live, but when I had even a trickle of users on the site it was HORRENDOUSLY
slow
Hi everyone,
Some quick background before I get to my question:
I have developed a fantasy football game that is based on an auction style
format. In any given game there are a consistant number of players, usually
10 or 12. There can be more than one game taking place at the same time on
the s
Hi everyone,
Some quick background before I get to my question:
I have developed a fantasy football game that is based on an auction style
format. In any given game there are a consistant number of players, usually
10 or 12. There can be more than one game taking place at the same time on
the
Hi everyone,
Some quick background before I get to my question:
I have developed a fantasy football game that is based on an auction style
format. In any given game there are a consistant number of players, usually
10 or 12. There can be more than one game taking place at the same time on
the
5 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Multi-user / transactions question..
Jeremy Smith said:
>
> A typical auction lasts around
> 90 minutes, and consists of a whole lot of furious refreshing of the
> auction board by the participants since each player only h
Does it make sense to use a transaction just for the row locking properties,
and then not needing to error check?
I have a situation where I have seperate files that are being run very often
in realtime by many different users. One is calling a list of 12 football
players. The other is updating
