Re: [mv] mySQL Database

["Christopher P. Lindsey" <lindsey@mallorn.com>]

******    message to minivend-users from "Christopher P. Lindsey" <lindsey@mallorn.com>     ******

> >    Database products NAME code price description
> 
> There is a select * from <table> in the code witch caused my db with 
> 500.000 titles to need 45 min for startup. Patching the select with 
> LIMIT helps out. Anyway enabling glimpse makes sence, because searching 
> in sql is not as fast as needed.

Adding a similar NAME line to my catalog.cfg prevented the initial select *
for my "products" table, so startup was significantly faster.

Quick and easy way to extract it from mySQL:

   foreach i ( `echo "describe [tablename]" | ./mysql -u [username] -p [database] | awk '{print $1}'` )
      echo "$i "
   end

Unless you meant that it's something in your catalog that's doing this?

Chris
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list