I doubt that a few thousand records would be more than mysql is capable of
handeling.
However my ignorance of Mysql is abundant.
Does it use the /tmp directory and is your /tmp or root partition small?
(guessing linux here).
Does mysql use the /tmp directory for temporary tables?
(Answer in ReadMe(s) probably)...
""Elliott Lee"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> Hi all,
>
> This may not necessarily be a PHP problem, but I was initially trying to
do
> this in PHP. I was trying to do a join of two tables and I get a response
> from MySQL saying that some SQL temp file was out of space. One of my
> tables has a few thousand items in it and my other table that I'm joining
> with is pretty small, maybe 15 items. Is there a limitation to the size
of
> the query that I can do? I'm not out of disk space either.
>
> Elliott
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
