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.
Existing users, log in. New users, create a free account. Lost password?
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.
Reply to This | Parent
Monday, February 27 2006 @ 11:02 AM PST