?
Solved

My SQL

Posted on 1999-06-26
6
Medium Priority
?
211 Views
Last Modified: 2010-04-21
Does any one know how many database, table, record and field can be open simultaneously on My SQL running on FreeBSD 3.2 ?

Andrew
0
Comment
Question by:andrewyu
6 Comments
 

Expert Comment

by:rolli
ID: 2011221
Memory dependent!
0
 

Author Comment

by:andrewyu
ID: 2011222
What will the answer be, if I have 1GB of RAM ?

Andrew
0
 
LVL 1

Expert Comment

by:dgb001
ID: 2011223
Hi Andrew,

I can't answer your question myself, but I know that there are some good SQL and possibly MySQL tutorials and resources at http://examware.com/tutor7.html which you might find of some use.

Good luck,
Dave.

0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 

Author Comment

by:andrewyu
ID: 2011224
Oh ......

Really thank you very much as I think you have already tried your best to help me !

Andrew
0
 

Accepted Solution

by:
decent earned 30 total points
ID: 2011225
There is no limitation on number of Tables, records etc to be opened. MySQL(or any another DB) provides almost inifinite threads for this. So, you can open as many as u can wherever u want(like through, JDBC, oDBC, in general DB etc.). I think this is u'r limitation(of being able to open so many of them) rather than the DB's problem. Though there are problems of consistency, timestamping etc when u open so many of these tables/records. You should be able to deal with that.
0
 

Author Comment

by:andrewyu
ID: 2011226
Ok, I get the answer !

I guess the answer of my question will be "depending on the power of the machine", right ?

Andrew
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tech tip describes how to install the Solaris Operating System from a tape backup that was created using the Solaris flash archive utility. I have used this procedure on the Solaris 8 and 9 OS, and it shoudl also work well on the Solaris 10 rel…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question