Posted by strawberry on 03/29/06 15:50

Spec as follows:

Intel Pentium 4 CPU 1700 MHz
1.69 GHz, 256MB RAM

I'm using xampp on WinXP Pro 2002 SP2

While the project's in development, I'm running it on my own machine.
This allows me to test things like the automatic creation of files and
folders without buggering up the file server. If/when we're happy that
the project provides a real benefit to our work then the plan is to
transfer everything across to the same machine as our dedicated file
server, and have it accessible from anywhere.

Some of the queries do use as many as four JOIN statements but the
example I cited originally really is pretty much as straightforward as
I described.

I'm not aware of any network-related troubles. I think everything works
in that regard.

With regards to Nicholas's post, I'm not sure that I give much thought
to the sensibility or otherwise of these sorts of things before I get
into them. I don't know if it's 'sensible' but it sure is nice to have
all that info neatly presented on a single page. :-).

If I could think of a satisfactory way to implement it then pagination
might be the answer - but I think I'll avoid it until the result set
gets a bit bigger. After all, although it takes a few seconds to
render, even a thousand entries doesn't really take that long to scroll
through.

With regards to J2Be's post, I'm perfectly happy to specify the columns
if it demonstrably speeds things up but the only problem (as I see it)
with this approach is just that if I add a field at a later date I have
to remember to modify the SELECT statement to reflect this change.

A couple of people have talked about caching. Thanks, I'll look into
that - and thanks everyone for all your input.

Cheers.

[Back to original message]