Re: This seems wierd.

[mike@minivend.com]

Quoting shane (shane@netnet.net):
> 
> I am on linux 2.x kernel RedHat 5.2, MySql Latest, Minivend 3.11 and Perl
> 5.0005_2
> 
> perl DBI lib's from mysql install..
> 
> OK..
> While running the server in debug mode I see these messages.
> Are these message easy to fix? How? Why does my browse1 page never really
> load after I load up the databse with 2000 products. It seems like it
> never finishes, I have it pointing to browse1 1:10 to only show 10 items,
> Do I need to do this completed in perl/sql to make it work faster?
> 

Update DBD::mysql.

Re browse, as I have pointed out multiple times, the browse page is not
reasonable to use for more than 100 products or so. This will not work
well for SQL without an ASCII search file, but for regular internal
MV databases I have attached a page "large_browse.html" which will
work OK for larger databases up to say 10,000 items.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
Fast, reliable, cheap.              131 Willow Lane, Floor 2  | ||  _ \
Pick two and we'll talk.            Oxford, OH  45056         | || |_) |
 -- unknown                         <mikeh@minivend.com>     |___|  _ <
                                    513.523.7621 FAX 7501        |_| \_\

Title: [L]Browse[/L] __COMPANY__

[body 1]

[perl arg=scratch] $start = tag_data('session', 'arg') || 1; $chunk = 1; if($start =~ /(\d+):(\d*)/) { $start = $1; $chunk = $2 || 1; } $prev = $start - $chunk; if($prev < 1) { $prev = 0; } $Safe{'scratch'}{'start'} = $start; $Safe{'scratch'}{'chunk'} = $chunk; $Safe{'scratch'}{'next'} = $start + $chunk; $Safe{'scratch'}{'prev'} = $prev; $Safe{'scratch'}{'not_shown'} = 1; return ''; [/perl]

[L]Browse[/L] __COMPANY__

[search-region arg=" ra=yes fm=[scratch first] ml=[scratch chunk] sp=browse tf=category to=f "] [search-list] [on-change 1] [condition][item-field category][/condition]

[item-field category]

[/on-change 1]

[if-field image]

[/if-field]

[item-description]

[L]Catalog[/L] [L]Number[/L]: [item-code]

[L]Price[/L]: [item-price]

[page [item-code]][/page] [order [item-code]][/order] [/search-list] [/search-region] [if scratch prev] [page href=browse1 arg="[scratch prev]:[scratch chunk]"] [L]Previous[/L]    [/if] [if type=explicit compare="[calc] [value mv_search_match_count] > [scratch next] [/calc]"] [page href=browse1 arg="[scratch next]:[scratch chunk]"][L]Next[/L] [/if]

---

[include pages/buttonbar.html]