[ic] Slower startup as Mysql tables grow
Tue, 20 Feb 2001 15:25:47 -0500
Quoting Jimmy Eaton (firstname.lastname@example.org):
> 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 <email@example.com>
Friends don't let friends use Outlook. -- Bob Blaylock