On 3 Jul 2009, at 09:42, Johan De Meersman wrote:
To be honest, this sounds like more of a filesystem thing, given that you only ever need to select the full set of an individual user. Just build up an FS structure with one file per user.
You really think so? Even though I'll need to initially create about 64k folders (keying off a user-id related hash) in order to keep files- per-dir down to a sensible amount? Its probably about now that I start wanting a reiserFS partition...
Marcus -- Marcus Bointon Synchromedia Limited: Creators of http://www.smartmessages.net/ UK resellers of i...@hand CRM solutions mar...@synchromedia.co.uk | http://www.synchromedia.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org