Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

My SQL

Posted on 1999-06-26
6
Medium Priority
?
198 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When you do backups in the Solaris Operating System, the file system must be inactive. Otherwise, the output may be inconsistent. A file system is inactive when it's unmounted or it's write-locked by the operating system. Although the fssnap utility…
Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
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

722 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