[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] HAS_LIMIT not documented (was: Large mySQL tables kill ICstartup)
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
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
