[ic] HAS_LIMIT not documented (was: Large mySQL tables kill IC
startup)
Ton Verhagen
ton@verhagen.net
Sat, 03 Mar 2001 11:38:09 +0100
Dear All,
I noticed that the configuration directive HAS_LIMIT is not documented.
Use this directive for large mySQl tables, or other SQl engines which have
'limit' support implemented.
If it is not used for large mySQl tables, IC will wait virtually forever at
server startup.
This is caused by IC doing a: 'select * from table' in subroutine
list_fields (lib/Vend/Table/DBI.pm). If you set HAS_LIMIT, the select will
read: 'select * fom table limit 1'. A real time/memory saver!
Hope this helps.
Best regards,
Ton