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!

Mar 5 '07 #1

Adrienne Boswell

Gazing into my crystal ball I observed "rdc.arch" <rdc.arch@gmail.com>
writing in news:1173068543.301889.274370@j27g2000cwj.googlegr oups.com:
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

Mar 5 '07 #2

Andy Dingley

On 5 Mar, 04:22, "rdc.arch" <rdc.a...@gmail.comwrote:
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.

Mar 5 '07 #3