I'm running v4.0.2 with postgresql v8.0 with 512Mb 1.3Ghz scsi drives in raid
1 on
Fedora Core 5.
o when I updated to 4.0.2 I found a bug and BAD sql code.
./includes/functions_mediadb.php has
$sql .= " ORDER BY RAND()"
Postgresql doesn't support but instead uses RANDOM()
so this failed.
I replaced RAND with RANDOM and it fixed this problem.
I recently attended a presentation given by Jay Pipes the North American
manager for
MYSQL on performance.
He specificly mentioned how bad this particlar statement was because MYSQL
had to scan the entire table
to return the answer. I guess the only saving grace is that , I'm guessing,
very few folks have
many MEDIA entries.
btw, I posted a problem record on sourceforge on this item.
Vince
--
View this message in context: http://www.nabble.com/V4.0.2-postgresql-bug-tf2638018.html#a7363569
Sent from the phpgedview-talk mailing list archive at Nabble.com.
|
