Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: How many mySQL tables is too many? (While working with DBI)

by screamingeagle (Curate)
on Feb 13, 2002 at 18:13 UTC ( #145230=note: print w/replies, xml ) Need Help??


in reply to How many mySQL tables is too many? (While working with DBI)

well, not knowing the details of your database schema will certainly hinder my reply. However, the general appraoch for database design is to make it conform to the Third Normal Form (3NF)
Here's are a few links to articles describing Data Normalization
Database Normalization Basics
First Normal Form
Second Normal Form
Third Normal Form hope this helps :-)
  • Comment on Re: How many mySQL tables is too many? (While working with DBI)

Replies are listed 'Best First'.
Re: Re: How many mySQL tables is too many? (While working with DBI)
by Anonymous Monk on Feb 13, 2002 at 19:12 UTC
    Hi, I just wanted to take a moment and thank you for your reply. I read all of those links and they were extremely helpful. It will certainly assist me in my design. Thank you!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://145230]
help
Chatterbox?
[PriNet]: i think i found the problem, the "source" array that sets the individual key values isn't being cleared, it's keeping the previous values...
[atcroft]: PriNet: You might consider posting a small, self-contained snippet of that segment of your code, and see if someone else has a better idea.....
[atcroft]: PriNet: Ahhh... interesting.
[PriNet]: small would be a problem *heh*... the program reads all the lines from a pdf and converts the individual colum data to a seperate key/value pair... that's where the "previous" array from the pdf is not being cleared properly before reading the next pdf
[atcroft]: PriNet: It was a thought....
[PriNet]: thanx... actually just having someone to talk to was making me think... *heh*

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (4)
As of 2017-06-28 03:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (620 votes). Check out past polls.