What do you mean, I don't undestand "What I - at a first glance - am missing are primary, unique and foreign key constraints. Is there a reason for this? I thought this is possible with MySQL, isn't it?"
-----Original Message----- From: Oliver Zeigermann [mailto:[EMAIL PROTECTED] Sent: Tue 11/25/2003 10:42 AM To: Slide Developers Mailing List Cc: Subject: Re: RE : MySqlRDBMSlAdapter Concerning URI length: I am with Christophe here: half the world restricts URIs to 255 characters and it should be enough for "normal" applications. As almost every request accesses the URI table it might be a performance problem using blobs. So I would propose to leave this for the default implementation. If you - Alexander - need longer URIs, no problem: provide the patch and I am very sure we find an additional solution. Maybe something called LongUriMySQLAdapter or so ;) What I - at a first glance - am missing are primary, unique and foreign key constraints. Is there a reason for this? I thought this is possible with MySQL, isn't it? Oliver LOMBART Christophe wrote: > if you have an uri greater than 255 char, I'm ok > No problem for the booleans > > I'm not sure for the indexes and PK : I have to check > > Thanks for your comments, > Christophe > > -------- Message d'origine-------- > De: Wendt, Alexander [mailto:[EMAIL PROTECTED] > Date: mar. 25/11/2003 10:24 > À: 'Slide Developers Mailing List' > Cc: > Objet: RE: MySqlRDBMSlAdapter > > > > Sorry, but your schema seems mysql-unlike/wrong to me. > > And Yes, I know this wasn't the problem in your mail. :-) > > > Don't know how if the uri.uri_string is redefined, but if not varchar(255) > doesn't fit (255-char-limit). - BLOB is what has to be. > > Then: > Primary-key is already an index, why double index i.e. uri.uri_id? > The is_variables meant to be boolean, nor? - If Yes, int(11) is much to big. > - Why don't take tinyint(1) or even varchar(1). > > > I'm not a mysql-expert, but couldn't anyone check this? > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > ------------------------------------------------------------------------ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
