Hello all,
I am trying to add a field to a very large table. The problem is that mysql
locks up when trying to do so. I even tried deleting the foreign keys on
the table and it wont even let me do that, again locking up.
It works for around 5 minutes or so then just either locks or the
Done. Thanks ;)
On Dec 28, 2007 1:41 PM, J Trahair [EMAIL PROTECTED] wrote:
In my experience, having a limit of a particular number of anythings per
something, eg. components per compound word is always a mistake, whether
it's the number of payments allowed to pay an invoice, the number of
On Dec 30, 2007 1:50 PM, donr2020 [EMAIL PROTECTED] wrote:
Our search engine does a master query INNER JOINed to a series of COUNT (*)
subqueries that return what the number of results would have been had the
user chosen different filters (or no filter at all). As an example:
Hmm. Why are you
At 12:51 PM 12/31/2007, you wrote:
Hi;
Is it possible to sort tables within a given database? How?
TIA,
Victor
Victor,
You mean physically sort the table based on a field or key so you
don't have to do an Order By clause each time you do a Select? Not really
because the order of the
Sorry, I didn't type the subqueries quite correctly. They all have the same
WHERE part (in this case, WHERE Col1 = X that essentially joins all the
queries.
There are six counts that we need and we first tested it as seven separate
queries; but that took about 20% longer than one nested set of
On Dec 31, 2007 3:05 PM, donr2020 [EMAIL PROTECTED] wrote:
Sorry, I didn't type the subqueries quite correctly. They all have the same
WHERE part (in this case, WHERE Col1 = X that essentially joins all the
queries.
It still doesn't make sense to me. Count queries don't return
anything to
