Jump to content


Photo

speed and data location


  • Please log in to reply
No replies to this topic

#1 stiphu

stiphu
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 03 October 2006 - 08:34 AM

Hi guys

I've got a few questions about mySQL:

1. I made a java interface to store and get data to a mySQL database over matlab. The interface works very well and very fast, if I don't have a lot of data in the tables. But if I have about 500'000 rows in a table, it takes a lot of time to load the data (about 2-3 sec). Is this normal?

2. I don't really get where the data is stored. I use MySQL Server 5.0 version 5.0.24a. I just see that there is a new folder (if i create a new database) with the name of the scheme and the information of the created tables. But where is the data i store? I just got that the file "ibdata1" is much bigger than before, so the data must be there. But I want to create a new scheme anbur this onto a dvd. I need portable data. Is this possible?

3. How can I erase data? I know how to erase a table or a scheme, but the data isn't really erased, because the file "ibdata1" is still the same size. I think this is maybe the same problem like in Nr.2!

Looking forward to your answers, thanx for your help,
regards Stephan




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users