No subject

>But the good news here is that you're only dealing with 2 rows in
>that part of the query, so even if it did have to use a temp table on
>disk, it should be really quick.
Good point, but if the disk is being wallopped by a delete (if data channels 
are not separated), or swap file.... any data may be delayed, and thus this 
could be an area to check.

(What is interesting on another point... on a new filesystem, only 16% full 
I have the following:
/mnt/store/1035_20070829210000.mpg: 9 extents found, perfection would be 10 
extents
/mnt/store/1035_20070902215900.mpg: 3043 extents found, perfection would be 
10 extents
One file create by copy, the other created by myth as it writes.
[root at fileserver cache]# ls -l /mnt/store/1035_20070829210000.mpg
-rw-r--r-- 1 root root 1109074792 2007-08-29 22:01 
/mnt/store/1035_20070829210000.mpg
[root at fileserver cache]# ls -l /mnt/store/1035_20070902215900.mpg
-rw-r--r-- 1 root root 1102324464 2007-09-02 23:01 
/mnt/store/1035_20070902215900.mpg
)

Gareth