[ic] Memory problem

Stefan Hornburg Racke interchange-users@interchange.redhat.com
Wed Jan 16 16:49:01 2002


Jon Jensen <jon@redhat.com> writes:

> On Tue, 15 Jan 2002, Peter Jakl wrote:
> 
> > I've traced thru the interchange server program and found out my memory
> > problem but need help as to why it is doing this. Without going into
> > great detail, a startup function attempts to load the database into
> > memory (opendatabase() ultimately calls import_database() for each table
> > including products). The problem is that my products table has over
> > 150,000 products and the interchange server is loading all the products
> > into memory. How do I stop this?
> 
> You may have mentioned which database you're using in a previous message,
> but I don't remember right now. Using MySQL on an already-imported
> database, here are the SQL commands Interchange issues at IC daemon
> startup time:
> 
> SHOW TABLES
> select * from country limit 1
> select * from gift_certs limit 1
> select * from userdb limit 1
> select * from options limit 1
> select * from affiliate limit 1
> select * from cat limit 1
> select * from pricing limit 1
> select * from state limit 1
> select * from area limit 1
> select * from merchandising limit 1
> select * from orderline limit 1
> select * from inventory limit 1
> select * from order_returns limit 1
> select * from transactions limit 1
> select * from products limit 1
> 
> This lets IC get all the column names, but LIMIT 1 keeps the database from
> wasting any effort collecting a large result set.
> 
> Not all databases support LIMIT, so that may be the problem you're having.

Presumably we can use select * from products where 0 = 1 on these
databases.

Ciao
        Racke

-- 
For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)