Advantages of multiple classes?

Moderator: crythias

Locked
Sophy978
Znuny newbie
Posts: 83
Joined: 06 Jul 2012, 22:01
Znuny Version: 3.1.5
Real Name: Sophy

Advantages of multiple classes?

Post by Sophy978 »

Hello, please forgive my questions if they seem stupid but I know nothing of databases.

What is the advantage of using multiple classes other than easily categorizing a group of similar products? For our business, we can use 1 class or multiple classes.
Does having multiple classes affect the db search speed? For example if I had two classes, and search in 1 class, is it faster than searching for an item with one big class?

Also how does this affect the Statistics module? Again if I am reporting on 1 of multiple classes or reporting from 1 big class?

Finally, do I have the same amount of space in a db, whether I have 1 big class or break it up into multiple classes?

Thank you.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Advantages of multiple classes?

Post by crythias »

Please explain the context for classes with respect to databases and how it relates to OTRS?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Sophy978
Znuny newbie
Posts: 83
Joined: 06 Jul 2012, 22:01
Znuny Version: 3.1.5
Real Name: Sophy

Re: Advantages of multiple classes?

Post by Sophy978 »

For example, we have:
5 product types
Is it better to have 5 classes for each type or have a single class in CMBD? The data fields in each type can be the same.
Locked