[ic] flex select freeze interchange
pollok at gmail.com
Fri Jun 9 05:05:52 EDT 2006
Many thanks for the hint.
I've tried the LARGE option, and is very usefull!
I've resolved yersterday morning the problem upgrading PERL to 5.8.8.
Is strange but now it function.
> > By some days I've a really strange problem with a table.
> > This table count more than 70000 record (but i've in other
> > ic- installations bigger tables, also 1million of records),
> > when I open the table with flex_select interchange loop and freeze!
> > The mysql log say me that the query is:
> > select * from generale
> > (generale is obviously the criminal table) the mysql status
> > say me that query is NOT in process, so I think that is not a problem
> > of mysql.
> > The "top" utility show that the cpu is 100% and memory usage
> > growth, growth, and growth to use all the physical memory and
> > the swap.
> > After 300 secs interchange kill the process
> > I've ported the table to another installation and the
> > flex_select works without problem.
> > I've updated interchange to 5.4.1 and all the perl modules to
> > the latest one.
> > The only things that is not similar from the server that I
> > use for this installation and the one that I've used in the
> > only working test is the perl and mysql release...
> > Someone have an idea of something that i'm making wrong?
> Does flex_select freeze for the other tables in this catalog?
> Can you install a fresh foundation on the same server you are having this
> problem, and copy the table to that and see if it works? If it does not,
> then I'd try first replacing the relevant pages in lib/UI/pages/admin
> (possibly flex_select). Weird things can happen for whatever reason.
> If it still does not, obviously it is likely your perl or mysql version and
> out of my technical expertise.
> However, on a large table, set it as so in catalog.cfg:
> Database mytablename LARGE 1
> Interchange will only show you input boxes to search it, instead of
> returning all records. It may work and you can leave it at that.
> interchange-users mailing list
> interchange-users at icdevgroup.org
E-mail: alessandro at polet.to
More information about the interchange-users