[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