Re: [WebDNA] How many fields can i have in a DB

This WebDNA talk-list message is from

2018

It keeps the original formatting. numero = 114391
interpreted = N
texte = 2008--Apple-Mail=_DE2F0FC6-E47E-477D-A59F-21EA85F07D97Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiThere is no limitation but consider how big the db will be and how =managing a large db would effect the performance of your application.Also consider how much data you would lose if the db crashed !!Consider breaking up the db into relational chunks.Consider an EAV model.Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@plsoftware.com.au> On 12 Sep 2018, at 16:52, Office wrote:>=20> How many fields can i have in a DB ?=20>=20> I have an idea that require many fields that will ease the search.> And i wonder if there is any limitation ? 256 ? 512 ? 1024 ?>=20> Please advice,>=20> Yariv Nachshon> http://www.plonter.co.il >=20>=20>=20>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list =talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: =http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: =support@webdna.us--Apple-Mail=_DE2F0FC6-E47E-477D-A59F-21EA85F07D97Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiThere= is no limitation but consider how big the db will be and how managing a =large db would effect the performance of your application.

Also consider how much =data you would lose if the db crashed !!

Consider breaking up the db into =relational chunks.

Consider an EAV model.

Kind regards

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@plsoftware.com.au

On 12 Sep 2018, at 16:52, Office <yariv.n@gmail.com> =wrote:

How many fields can i =have in a DB ?

I= have an idea that require many fields that will ease the =search.
And i wonder if there is any limitation ? =256 ? 512 ? 1024 ?

Please advice,

Yariv Nachshon
http://www.plonter.co.il

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us

=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us--Apple-Mail=_DE2F0FC6-E47E-477D-A59F-21EA85F07D97--. Associated Messages, from the most recent to the oldest:

Re: [WebDNA] How many fields can i have in a DB (Stuart Tremain 2018)
[WebDNA] How many fields can i have in a DB (Office 2018)

2008--Apple-Mail=_DE2F0FC6-E47E-477D-A59F-21EA85F07D97Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiThere is no limitation but consider how big the db will be and how =managing a large db would effect the performance of your application.Also consider how much data you would lose if the db crashed !!Consider breaking up the db into relational chunks.Consider an EAV model.Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@plsoftware.com.au> On 12 Sep 2018, at 16:52, Office wrote:>=20> How many fields can i have in a DB ?=20>=20> I have an idea that require many fields that will ease the search.> And i wonder if there is any limitation ? 256 ? 512 ? 1024 ?>=20> Please advice,>=20> Yariv Nachshon> http://www.plonter.co.il >=20>=20>=20>=20> --------------------------------------------------------- This message =is sent to you because you are subscribed to the mailing list =talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: =http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: =support@webdna.us--Apple-Mail=_DE2F0FC6-E47E-477D-A59F-21EA85F07D97Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiThere= is no limitation but consider how big the db will be and how managing a =large db would effect the performance of your application.