[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Slower startup as Mysql tables grow
Quoting Jimmy Eaton (jeaton@silverclicks.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 <mheins@redhat.com>
Friends don't let friends use Outlook. -- Bob Blaylock
_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users
