severndigital Posted January 11, 2008 Share Posted January 11, 2008 I am preparing to start a project that will manage several large databases. As of this moment, the databases will not be accessed simultaneously. however, the project will allow for sorting and also for criteria defining. the system will then allow for export of the selected rows in the database. the total amount of entries will be approximately 300,000. the databases will range from 30 - 80 fields to search from. My question is, what is the best way to store these databases? Should I import them into different tables in mysql or should I import the name and location of the them on the server and open them via flatfile? thanks, -C Quote Link to comment Share on other sites More sharing options...
fenway Posted January 11, 2008 Share Posted January 11, 2008 Database of what? Quote Link to comment Share on other sites More sharing options...
severndigital Posted January 15, 2008 Author Share Posted January 15, 2008 customer lists essentially Quote Link to comment Share on other sites More sharing options...
fenway Posted January 15, 2008 Share Posted January 15, 2008 And what would your fields represent/ Quote Link to comment Share on other sites More sharing options...
severndigital Posted January 16, 2008 Author Share Posted January 16, 2008 And what would your fields represent/ customer information. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 17, 2008 Share Posted January 17, 2008 80 fields of customer information? Quote Link to comment Share on other sites More sharing options...
severndigital Posted January 17, 2008 Author Share Posted January 17, 2008 What is the difference how many fields there are, and what they pertain too?? but to answer your 3rd. non-helpful question. YES 80 Fields of customer information. We are not simply housing an address. If we were housing an just an address I would not have asked such a question. Why would I lie about it? I am asking for help. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 17, 2008 Share Posted January 17, 2008 What is the difference how many fields there are, and what they pertain too?? but to answer your 3rd. non-helpful question... Actually, you haven't been very helpful either.... all you've told us is that you have 300K magical records with 80 magical fields. And then you want to know how to store this. So I'm trying to get more information, but you're not forthcoming. Perhaps someone else on the forum is psychic. That's like saying "I need a good car to get me places... which one should I buy"? If you'd like specific details, provide some detailed information from your end so that we can assess your problem in a meaningful way. And if you don't understand why the number & type of fields you're storing matter, well, there's a lot of work to do. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.