Existing users, 
Version:
Not very usable
Feedback Type: Commentary
Contributed by: bichufo Wednesday, February 22 2006 @ 06:20 AM PST
Product Platform: MacOSX
Used Product For: Less than a month
Recommend Product: NO
Tried this. Connects OK, has a nice interface but... seems to be for teeny-weenie tables. It will never finish loading a 75,000 record table although I've put 2000 as a limit on records. I've got 512MB of RAM but this really gets my Mac Mini huffing and will not let me do anything else. I have to Force Quit to be able to get my Mac back!
Comments
Why limit to 2000? - bichufo
Well, when you have tables with over 800,000 records and you are looking for say, clients that meet certain criteria, you want to be able to output more than a few hundred records, specially if you sort by paricular fields.I am perhaps trying to do things not meant for this app. Queries for data cleansing, for example, which return lots of records.
If tables are small (few records) then this app does the job very well.
Wednesday, February 22 2006 @ 06:55 AM PST
Still, why limit to 2000? - McClie
Even if from your 800,000 records you select all client orders in the past year and get 35,000 records in your result, the point remains. This is still more than 2000. The limit does not mean that you only ever see 100 records (it is not the same as limit in mysql, but the programme is at fault for telling you that there are "100 records in the table"). You go to the bar which says on mine "100 row limit starting ar record 1", If I click on the up arrow beside the box with "1" it becomes 101, and I can now view the next hundred. I repeat, many people administer databases using phpMyAdmin, which defaults to a "limit" of 30 (it has the useful extra of being able to go straight to the final page of records, which I wish Cocoa-MySQL could manage because it falsely reports the size of the table as the size of the "limit").Admittedly my largest database is only 15,000 records, but the SBG version with a 100 hundred limit handles that well even when I access a view of it that left joins it to a 10,000 record names database.
Monday, February 27 2006 @ 11:02 AM PST
Not very usable - CBHH
CocoaMySQL-SGB introduced a change in the handling of record limits: you can (and should!) set the limit for each favorite separately. Obviously, the limit defined for a favorite overrides the general limit preference, which can lead to the problem you described.Tuesday, February 28 2006 @ 03:46 AM PST
Not very usable - Rich_TO
Oh it's usable. You just have no patience.Thursday, June 22 2006 @ 11:05 PM PDT
Why limit to 2000? - McClie
Why is your limit as high as 2000? Do you realy want to browse through that much. My limit is set as 100 and for the most part I search for items rather than browse. As you are not browsing for the whole 78,000, why is browsing through 2000 any better? Most phpMyAdmin users operate with a limit of 30.Reply to This
Wednesday, February 22 2006 @ 06:36 AM PST