IT Community - Software Programming, Web Development and Technical Support

how many tables do we keep for one database in mysql?

This is a discussion on how many tables do we keep for one database in mysql? within the Database Support forums, part of the Web Development category; hi, how many tables do we keep for one database in mysql? is there any limitation on this?...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1  
Old 05-16-2007, 12:30 AM
Jeyaseelansarc Jeyaseelansarc is offline
D-Web Genius
 
Join Date: Mar 2007
Location: Chennai
Posts: 1,165
Jeyaseelansarc is on a distinguished road
Send a message via AIM to Jeyaseelansarc
Default how many tables do we keep for one database in mysql?

hi,
how many tables do we keep for one database in mysql?
is there any limitation on this?
__________________
With,
J. Jeyaseelan

Everything Possible
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 05-16-2007, 05:43 AM
vadivelanvaidyanathan vadivelanvaidyanathan is offline
D-Web Genius
 
Join Date: Feb 2007
Posts: 801
vadivelanvaidyanathan is on a distinguished road
Default Re: how many tables do we keep for one database in mysql?

There is no limitation on that.But if we create many tables in same database directory, open, close, and create operations are slow.

-V.Vadivelan
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I convert a Access database to a MySQL database? itbarota PHP Programming 2 09-13-2007 09:04 AM
What are the different tables present in mysql, which type of table is generated when oxygen Database Support 2 07-26-2007 02:37 AM
What is the Query to display all tables and Database names in server use sql? kingmaker Database Support 2 07-23-2007 09:57 PM
Tracking all DML and DDL Statements in Database Tables - MYSQL Murali Database Support 6 07-16-2007 02:31 AM
How to import foxpro tables into MySQL Databases priyan Database Support 2 05-21-2007 06:11 AM


All times are GMT -7. The time now is 06:02 PM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.
Our Partners
One Way Moving Companies | Stamford Dentist | Euro Millions Lottery | Home Loans| Furniture

SEO by vBSEO 3.0.0