Find the answer to your Linux question:
Results 1 to 2 of 2
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    How should i go about creating a database the text book way?

    Installed MYSQL, created an identical database structure to that of my current SQL database(windows - i use linux now) however it takes over 1 minute for my software to access the data, and thats on a blank database.

    Is there any specific tables, or order in which tables / databases should be created, or perhaps perameters / variables that need to be amended or created?

  2. #2
    Linux Enthusiast
    Join Date
    Jun 2002
    San Antonio
    An empty database should be accessed in less than a second. If you are getting long timeouts, it is almost definately because you are waiting on RDNS. Add entries to your /etc/hosts files for each machine, and this problem should vanish.

    I get sub-1 second queries on databases up to 2 GiB in size if indexed properly.


    I respectfully decline the invitation to join your delusion.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts