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
anythin
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 o
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 tabl
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 a
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 o
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 data
