Re: Upgrading to v7.2 ?

In article <A0QAxCAlUJiyEwzq@georgeson.co.uk>, Martin <martin@georgeson.co.uk> writes >>>> We currently have v5 of informix on a compaq prosignia unix/sco server >>>> with 56MB ram, 3GB drive and a pentium overdrive chip. >>>> >>>> Will this be sufficient if we upgrade to v7.2 of informix? >>> >>>Should be - depends on your app. >>>-- >>>Ciao, >>> >>>Billy >>> >>>I'd be in favour of apathy, but I just can't get >>>fired up about it... I would reply to that but I can't be bothered. >> >> How many users will you have on the system? > 10 >> How large is the database? > 2.2 GB >> What is the application? > 4GL /ESQL /Client Server >> How many rows in the largest database table? > 600,000 >> How many processors does the machine have? > Just the 1 486/66 plus pent overdrive >> >> A bit more info would help :-> >All the best and many thanks >> > >Martin Man I would say this is borderline for 10 users, each user can use up to 5Mb (this is the limit on memory used for a sort), 5*10 = 50Mb!. You may get away with it. Remember you also need memory for Online buffers, probably at least 10Mb (Rough guess based on previous experience - don't flame me). Sorry but this is too close for me to judge, we have about the same size database with 40 users and have 256Mb of memory, 10 users would be 64Mb. -- David Williams