Hello,
I am using biomart with a postgres database (7.4).
And all seem work perfectly with the count of the results but I can
not obtain a good table with an 'export' or a 'view all results'.
When I see the log4 log, I can remark that the query is split in many
sql
using LIMIT and OFFSET... So why not ...
but I do not see an ORDER BY command and this parameter seems to be
necessary to obtain my good results...
SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key
AND dm.field =t LIMIT 200
SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key
AND dm.field =t LIMIT 200 OFFSET 200
SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key
AND dm.field =t LIMIT 400 OFFSET 400
instead of :
SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key
AND dm.field =t ORDER BY main.key LIMIT 200
SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key
AND dm.field =t ORDER BY main.key LIMIT 200 OFFSET 200
SELECT main.name,[dm_table].field FROM main, dm WHERE main.key=dm.key
AND dm.field =t ORDER BY main.key LIMIT 400 OFFSET 400
That is a problem with postgres versus MySQL (I do not have any
experience with MySQL) or a problem with my config ... or something
else ?
Any suggestions
Thanks
Olivier
--
Olivier Arnaiz
CGM-CNRS
91198 Gif-sur-Yvette
01 69 82 43 75
ParameciumDB:
http://paramecium.cgm.cnrs-gif.fr/
