Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is 78 fields per table too much??
Message
 
To
15/06/2004 07:34:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00913804
Message ID:
00913814
Views:
12
Donald, the answer is no, it is not too much, I have some tables with more than 200 fields without any problem, unless you are running your application over a slow connection.

>I am building an additional table (.DBF) for my VFP8 application. I'm trying to normalize, de-normalize to maxium efficiency. If this data does not need to be split up (normalized) between 2 or more tables, I'd prefer keeping it in one table. I'll have at least 78 fields (13 distinct entities times a multiple; eg. 6 sets = 13 * 6; 7 sets = 13 * 7, etc.)
>
>Thanks,
>
>dbk
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Previous
Reply
Map
View

Click here to load this message in the networking platform