[pLog-svn] r3167 - in plog/trunk: . install

[Mark Wu]

 Hi Christoph:

Nice, we really need someone's help to let us know know how to improve our
database design.

Right now, Oscar already run lifetype in lifetype.net and his personal web
site, so I think maybe he can give you some information if you can give us
the necessary  instructions.

And, I also run lifetype 1.1 everyday, but only in development environment.
If you think it is still worth to know my development enviroment
information. I love to help.

And, I remember Jon also run lifetype in his website (not so sure), so ...
Maybe he also can provide the information you need.

Mark

> -----Original Message-----
> From: plog-svn-bounces at devel.lifetype.net 
> [mailto:plog-svn-bounces at devel.lifetype.net] On Behalf Of 
> Christoph Feddersen
> Sent: Saturday, April 01, 2006 12:53 AM
> To: plog-svn at devel.lifetype.net
> Subject: Re: [pLog-svn] r3167 - in plog/trunk: . install
> 
> If you're interested in some database optimizations, I should 
> be able to  have a closer look at the scheme and the queries 
> within the next two weeks. Database design and optimization 
> is part of my daily job.
> 
> For query optimization, it would really help to get 
> information from a productive 1.1 system. I know that some of 
> you are already running 1.1, would anyone configure his mysql 
> server to log the mysql queries if I supply the necessary 
> instructions?
> It should be a mysql server that is running Lifetype only. 
> Logging should be activated 24h, more would be better.
> 
> Christoph
> 
> Jon Daley wrote:
> > On Fri, 31 Mar 2006, Mark Wu wrote:
> >> I am not sure which table use what kind of  table type is more 
> >> proper, so, I set all of them as "TYPE=MyISAM" ..
> >>
> >> I will leave this part for you to decide which table  us innoDB
> > 
> >     There is at least one forum post from a guy who sounds like he 
> > knows what he is talking about, and he had a number of 
> suggestions on 
> > which table is which.
> > _______________________________________________
> > pLog-svn mailing list
> > pLog-svn at devel.lifetype.net
> > http://devel.lifetype.net/mailman/listinfo/plog-svn
> 
> _______________________________________________
> pLog-svn mailing list
> pLog-svn at devel.lifetype.net
> http://devel.lifetype.net/mailman/listinfo/plog-svn