On 8 Feb 2004, at 20:28, Mark Hazen wrote:
My tables are just 2 INT columns. I have unique indexes on them going
both
ways.
Sounds like you're sorted.
You know, this might sound strange, but does the performance drop off at
all if you lose the indices? A table scan of rows 8 bytes wide is goin
On 8 Feb 2004, at 19:37, Mark Hazen wrote:
*snip*
Here's my problem: I've got a bunch of tables with hundreds of
millions of
rows in them. Every night, I delete about couple million rows and
then run
millions of searches on these tables.
What should I worry about more? A sorted index or a da
On 8 Feb 2004, at 1:33, Marty Ray wrote:
I am new to mysql and I am having trouble getting started. I am using
a Macintosh G5 running OS 10.3.2. I got mysql installed and it would
run, however when I tried to create a database, I got an error saying
permission denied. I tried running the script
On 6 Feb 2004, at 14:38, Erich Beyrent wrote:
This seems really efficient, since the only large number of rows to
search against is the main listings table, if I read this right. Is
there any further optimization that I can do, or this as good as it
gets? Believe me, I am NOT complaining!!!
Yes,
On 4 Feb 2004, at 20:32, Dan Muey wrote:
We are implementing three or four MySql servers (as a start)
and I'm writing the Troubleshooting Guide for our operational
staff. None of these folks have any MySQL experience (and
I'm a newbie myself). I need a pretty basic 'Cheat Sheet' for
troubleshooti
marko milovanovic <[EMAIL PROTECTED]> writes:
> uh! i already posted this message a while ago!
> could anyone please help me?
>
> i could find some informations about increasing the size of the
> databases, but not about limitations to their size.
>
> how would it be possible to set a limitatio
"Patrick FICHE" <[EMAIL PROTECTED]> writes:
> I just wanted to know if my assertions are rigth and what are the common way
> to solve this type of problems ?
Store your results into a temporary table?
--
Dave Hodgkinson, http://www.hodgkinson.org
Editor-in-chief, Th
