|Subject||Re: [ib-support] Further to Performance Issue|
> I *don't* subscribe at all to the suggestion that you do these complex calcNever say never <g>
> runs on the client. Correct your structures and run these processes on the
> server. As you rightly observed, that's what C/S is for.
My suggestion was 'supposed' to be pointing out the
principle of breaking a problem up. Once you know where the
problem is, then part of it may be improved by a little
client help rather than 'expecting' the best results from
clobbering the server with everything. Having seen some of
the queries people generate and expect to be 'instant'...
FastReport will generate results in seconds when an
optimised set of queries is provided, where a single complex
query can take minutes to generate the same results. Reduced
impact on the server, but the same end result. ( And
IBONative is even faster but that is another story <g> )
L.S.Caine Electronic Services