Jump to content

How many Fields in one database?


This topic is 8474 days old. Please don't post here. Open a new topic instead.

Recommended Posts

quote:

Originally posted by jayme:

Do you know what the estimated limit should be on the amount of fields in one database? Is 130 too many?

I have some databases with over 700. It really depends upon what you are storing in those fields. The database files each have a 2GB limit.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

  • Newbies

Thanks Kurt. I was just reading that repeating fields are not recommended if you want to utilize that data in reports. I have 52 repeating fields with 15 repetitions each. Is the Que Publishing book really recommending that I create 780 fields (52x15)? Isn't there a better way to go about this?

quote:

Originally posted by captkurt:

I have some databases with over 700. It really depends upon what you are storing in those fields. The database files each have a 2GB limit.


Link to comment
Share on other sites

This topic is 8474 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.