Categories

See More
Popular Forum

MBA (4887) B.Tech (1769) Engineering (1486) Class 12 (1030) Study Abroad (1004) Computer Science and Engineering (988) Business Management Studies (865) BBA (846) Diploma (746) CAT (651) B.Com (648) B.Sc (643) JEE Mains (618) Mechanical Engineering (574) Exam (525) India (462) Career (452) All Time Q&A (439) Mass Communication (427) BCA (417) Science (384) Computers & IT (Non-Engg) (383) Medicine & Health Sciences (381) Hotel Management (373) Civil Engineering (353) MCA (349) Tuteehub Top Questions (348) Distance (340) Colleges in India (334)
See More

In terms of today's technology, are these meaningful concerns about data size?

General Tech Technology & Software
Max. 2000 characters
Replies

usr_profile.png
Alice Davidson

User

( 3 months ago )

 

We're adding extra login information to an existing database record on the order of 3.85KB per login.

There are two concerns about this:

1) Is this too much on-the-wire data added per login?

2) Is this too much extra data we're storing in the database per login?

Given todays technology, are these valid concerns?

Background:

We don't have concrete usage figures, but we average about 5,000 logins per month. We hope to scale to larger customers, howerver, still in the 10's of 1000's per month, not 1000's per second.

In the US (our market) broadband has 60% market adoption.

usr_profile.png
Mike Franklin

User

( 3 months ago )

Assuming you have ~80,000 logins per month, you would be adding ~ 3.75 GB per YEAR to your database table.

If you are using a decent RDBMS like MySQL, PostgreSQL, SQLServer, Oracle, etc... this is a laughable amount of data and traffic. After several years, you might want to start looking at archiving some of it. But by then, who knows what the application will look like?

It's always important to consider how you are going to be querying this data, so that you don't run into performance bottlenecks. Without those details, I cannot comment very usefully on that aspect.

But to answer your concern, do not be concerned. Just always keep thinking ahead.

what's your interest


forum_ban8_5d8c5fd7cf6f7.gif