[ic] Scared.

Jonathan Clark jonc at webmaint.com
Tue Jul 29 10:07:00 EDT 2003


> > Just remember that investing one or two hours for expert consulting
> > is usually better than an angry customer - in the case you run into
> > a block of stone during your project.
>
> Racke -
>
> I think that is excellent advice.  What are your rates?
>
> This project will be fairly low volume of sales.  Will choosing a
> flat file system over a
> SQL DB make a huge difference in performance?

We always go for a SQL database, even for low volume sites. I find there are
always times where it comes in handy. For example, say you want a drop-down
for a search where the list is built from the product groups _currently_ in
the products table (a SELECT DISTINCT query).

For the low volume sites, it always came down to the number of products -
more products means slower searches. 2 seconds plus for search results
starts to become a pain. If you have 20 products you are unlikely to have a
problem, if you have searches returning 50+ results, I would go SQL.

Also, for IC 4.9, SQL is required for setting up/ using tree menus with the
excellent new menu builder in the UI.

Good luck on your first project!

Jonathan.

--
Jonathan Clark
Webmaint.com - Building Clever Websites   http://www.webmaint.com/
Webmaint.net - Business Web Hosting       http://www.webmaint.net/




More information about the interchange-users mailing list