Page 1 of 1

Large Data Entry from Form help

Posted: Mon Jan 26, 2009 8:22 am
by oscardog
So the plan is that the user will access a page, this is mostly done, just the main hard part to go.

Now they can input planner entries, so from 6am-10pm or whatever throughout the day they can put one entry in per hour - i'd love to have it so they could be more specific - so like '6.00, 6.15, 6.30, 6.45, 7' etc so if you can work that in, that'd be a bonus but..

I know how to do it with a form and textfields, and they submit it and it enters a database - I'm not that nooby ;)

But say im a really active user, and put my whole years plans in, and there are roughly 10 entries I put in per day... thats 3650 entries per year, thats just one person, that's going to eat a database. So what im asking is what is the best way of doing this, so that i can conserve some database space, and also how many entries(roughly) could i fit into a standard MySQL database(on a standard webshost, that is payed for)

Ashley/Oscardog

Re: Large Data Entry from Form help

Posted: Mon Jan 26, 2009 9:04 am
by mattpointblank
If you're just storing basic text strings / times, thousands of rows won't be particularly large in terms of storage. Just make sure you use appropriate data types for the columns and use a sensible database relation structure.

Re: Large Data Entry from Form help

Posted: Mon Jan 26, 2009 10:00 am
by oscardog
Thanks :)

What is a database relation structure?

Also say i get a full database, and i need to say have 'DB_DIARY_ENTRIES1' and then 'DB_DIARY_ENTRIES2' how would i then use a select statement on both, or would i have to them separate?

Re: Large Data Entry from Form help

Posted: Mon Jan 26, 2009 11:06 am
by mattpointblank
You'd have to do separate queries, since you can only be connected to one database at a time.

Relational database structuring basically refers to a mode of storage that prevents repeat/duplicate information... sorta. It's hard to sum up, but read up here: http://dev.mysql.com/tech-resources/art ... ation.html

Re: Large Data Entry from Form help

Posted: Mon Jan 26, 2009 4:58 pm
by oscardog
*Blinks* After reading it several times, i think i got it - thanks for the help!