Help! Slow Loading Issue-information management

[rdc.arch]

Hello all - let me start by saying i am an architetural designer, not
a web designer - but my wife is just starting a business and we can
not fford to hire a website designer so i have created www.artstudioshanti.com
- it is more of a portfolio than an online store, but eventually my
need to become an online store - also, as she adds more items the
loading gets slower because of the way i have written it - what i am
trying to achieve is a clean interface that does not reload when you
switch galleries, but simply loads the new gallery in place - i have
done this through javascript so far, but as more items are dded this
is going to get unweildy - and, if there were some way to just add
thumbs, images, and text files and have them added to the site by some
server side magic i would be very happy -

so, my question is mostly, what sshould i be researching to figure out
how to make this work? i have heard ajax and mysql thrown around but
know nothing of either - any help would be greatly appreciated!

[Adrienne Boswell]

Gazing into my crystal ball I observed "rdc.arch" <rd******@gmail.com>
writing in news:11**********************@j27g2000cwj.googlegr oups.com:

Hello all - let me start by saying i am an architetural designer, not
a web designer - but my wife is just starting a business and we can
not fford to hire a website designer so i have created
www.artstudioshanti.com - it is more of a portfolio than an online
store, but eventually my need to become an online store - also, as she
adds more items the loading gets slower because of the way i have
written it - what i am trying to achieve is a clean interface that
does not reload when you switch galleries, but simply loads the new
gallery in place - i have done this through javascript so far, but as
more items are dded this is going to get unweildy - and, if there were
some way to just add thumbs, images, and text files and have them
added to the site by some server side magic i would be very happy -

so, my question is mostly, what sshould i be researching to figure out
how to make this work? i have heard ajax and mysql thrown around but
know nothing of either - any help would be greatly appreciated!

DB is the way to go:

CREATE TABLE products
(add id AUTO-INCREMENT PRIMARY KEY,
img VARCHAR(50),
thumb VARCHAR(50),
description VARCHAR(250),
title VARCHAR(50),
added DATETIME,
price DOUBLE,
lastupdate DATETIME,
status VARCHAR(2)
)

SELECT img, thumb, descripption, title
FROM products
ORDER BY title

You can put all your images (not the images themselves, but the path to
the image), text, title, price, etc. into a table and query the table to
get the information out again.


--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

[Andy Dingley]

On 5 Mar, 04:22, "rdc.arch" <[e-mail]:

trying to achieve is a clean interface that does not reload when you
switch galleries, but simply loads the new gallery in place

Just do it the simple way, and then have the web server serving it
from static pages. It's simple to get working and perfectly fast
enough.

You can use an "off line" database if you want, where an off-line
database export process generates HTML pages that are then uploaded as
static pages. This is simple, but still gives you the benefits of
automatically generated navigation.

You don't need a "live" database until you're doing either searches or
on-line sales. Then look at running a pre-built web shop catalogue,
rather than writing your own.