I'm building an app that will utilize a MySQL5 database over the web using a VFP9 client. I've read the MySQL book about FIXED rows being quicker (just as we know in VFP) for MyISAM tables but the cost is space. The alternative is to use a DYNAMIC row format, which won't waste space, but the con of that is that searches may take longer and there's more chance for fragmentation over time.
At first thought, I'd opt for the DYNAMIC row format so that the transmissions across the "network pipe" (the path between client app and the web database) were as lean as they could be, assuming a smaller transport size (?? am I right to say that if the fields are truly utilizing the VARCHARs?); however, the fragmentation makes me wonder if I'd be better off using the FIXED row format in the long run. Size of the database isn't a concern for this project...but I want to keep the transported data size to a minimum due to this being a web database (even though I know my client has a Comcast high speed cable modem connection). I know this isn't a MySQL question per say as it could easily be SQL Server on the local network instead. Every SQL Server project I've come into however always utilizes the DYNAMIC row format, though, so hence there's the apparent bias in design. Which would you opt for if this were your project? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
