[ic] Slower startup as Mysql tables grow
Tue, 20 Feb 2001 15:25:47 -0500
Quoting Jimmy Eaton (email@example.com):
> As the number of records grow in a table the longer it takes for the
> catalog to startup. If I delete the records startup is much faster. Is this
> a Mysql problem? I presently have Minivend 4.04. Is this better in
> Interchange? Why does slow down? Is it bringing in all the records?
That is it. It uses a select * from something to get the field names.
The solution is to update to Interchange 4.6.3, where if you are using
MySQL it will use a "limit 1" to keep that time to the minimum.
You could also find the place in Vend::Table::DBI where it does
that and hardcode a "limit 1" yourself.
Red Hat, Inc., 131 Willow Lane, Floor 2, Oxford, OH 45056
phone +1.513.523.7621 fax 7501 <firstname.lastname@example.org>
Friends don't let friends use Outlook. -- Bob Blaylock