Does it matter what data type I use from database?

Question

0.00/5 (No votes)

See more:

I use SQLite with my C# winform project and use only Text as data type for everything latter I convert data using code according to my need I just want to know if data type makes deference on running speed?

What I have tried:

I know nothing about databases.

Posted 1-Jul-21 1:29am

NaseerAhmad007

Updated 1-Jul-21 2:20am

Add a Solution

Comments

PIEBALDconsult 1-Jul-21 9:59am

Only if performance is important.
You can even use XML as a "database" as long as performance isn't critical.
If you find it "fast enough", then go for it.
But don't expect your boss to be impressed.

2 solutions

Solution 2

Always use the appropriate datatype: it takes you a couple of minutes to set up and to insert your values, but it saves you hours (or even days) later when you want to us eteh data.

Since you should always use parameterised queries to access your DB (google for "SQL Injection" to se why) it also helps prompt you to check user input and convert it to the right datatype before it gets near the DB - instead of finding it was garbage three months later when you want to do a total, or print a report for a single month for example.

Posted 1-Jul-21 2:20am

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Accepted Answer · 2021-07-01T01:55:00

Solution 1

Using the correct type in the database has numerous advantages. Aside from not needing to parse the value in your code, which will slow things down, your data will take up less space, and will prevent you from storing invalid values which would later fail to parse.

Posted 1-Jul-21 1:55am

Richard Deeming

Comments

Kelly Herald 2-Jul-21 13:18pm

I agree. A very good example is never ever store a date or date/time as text in a database. First it takes up more storage in the database. Second a date format in one region will not parse correctly in a different region.

NaseerAhmad007 5-Jul-21 7:06am

I'll keep in mind thanks.