Results 1 to 12 of 12
  1. #1
    Join Date
    May 2004
    Posts
    8

    Exclamation I need a big database access, sql or mysql

    Dear friends,

    I have a performance testing project.

    Could anyone send me or tell me for a link to download a big size database containing lots of records.

    Please help urgent

    Regards,

    HotBird

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    What sort of records. Most people will have problems sending stuff out due to privacy issues.... but depending on what you want I might be able to fake a pile of data for you....

  3. #3
    Join Date
    May 2004
    Posts
    8

    Talking what i need

    Dear Sir,

    Thank you for replying,

    I need a database with relationships mysql or MS access or MS SQL,

    any kind of records like stock, emplyees, acct, etc...

    Thanks a lot for your help.

    Regards,

    HotBird

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Use Northwind and add records?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Performance testing, but you don't care if it's for mysql, access, or MSSQL? You'll have huge performance differences between Access and just about any other RDB...

    Why can't you just loop through an INSERT several thousand times to create a table? You can add some logic into your loop to make them unique...
    That which does not kill me postpones the inevitable.

  6. #6
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    The type of data will also affect your performance testing. Also the structure of your data. If you have no desired structure, no target platform and no intended data content then your performance testing is a complete waste of time.

  7. #7
    Join Date
    May 2004
    Posts
    8

    Please give me a ready made mysql script

    Dear friends,

    Thanks for your replies,

    In my university they ask me to bring a mysql script to create tables and insert data into them. so if anyone of you have this script or have the script which creates the northwind tables so please give it to me.

    This project is to let the students understand the difference between several database types and to see the performance.

    if there is any free tool that converts the access db to a mysql script please inform me.

    Thanks a lot
    HotBird

  8. #8
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    So how do you plan on learning to do this if the scripts are written for you?
    That which does not kill me postpones the inevitable.

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Quote Originally Posted by Seppuku
    So how do you plan on learning to do this if the scripts are written for you?
    What makes you think that hotbird is interested in this "learning" stuff? At least from what I can see, the only real interest is getting the assignment completed.

    -PatP

  10. #10
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    Welcome back Pat
    That which does not kill me postpones the inevitable.

  11. #11
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    350K FAA Aircraft database records found at
    http://registry.faa.gov/ardata.asp

    Cheers
    sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  12. #12
    Join Date
    May 2004
    Posts
    8

    Talking Thanks friends

    Dear Friends,
    Thank you very much for your replies,
    I already downloaded the airmen database it's a big db but it only contains one table.
    Anyway it gave me a good experience as a first time running a large enaugh database.

    if you have resources or pdf books to share with me about using ADO 2.6 or mastering ADO 2.6 I'll be thankful.

    Regards,
    HotBird

Posting Permissions

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