Gossamer Forum
Home : Products : DBMan : Customization :

How many fields can be used?

Quote Reply
How many fields can be used?
What is the highest number of fields that can be used? I'm going to have 59 in my upcoming database. Will this overload the script in any way?

-Blake
Quote Reply
Re: How many fields can be used? In reply to
You can have as many fields as you like. The important thing to remember is that the more fields and the more select fields you have, the longer the web pages will take to download.

The important thing in terms of search efficacy and management of your database is that your database file (.db) does not exceed 1.0 MGs. If you anticipate that you will exceed this amount, then it would be wise to consider purchasing a SQL license, since that version handles server processing much more efficiently than using ASCII Flat Files.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us
Quote Reply
Re: How many fields can be used? In reply to
I have run into trouble if there were more than about 150 fields. It seems there is some sort of maximum number of fields that can be shown on a form.

Otherwise, I agree with Eliot.

------------------
JPD