Re[2]: Improving Query speed - any suggestions?

2003-10-23 Thread Peter Buri
mdisk idea, I read about MB> someone else who tried that and had some success. Beyond, that I'm gonna MB> take the long route and redesign the database to be a bit more MB> conventional. MB> Thanks! MB> Matt MB> On Thu, 2003-10-23 at 20:28, Peter Buri wrote: >> Hello,

Re: Improving Query speed - any suggestions?

2003-10-23 Thread Peter Buri
Hello, as i see you use one table to store all the data, but the cohesive data are split into 15! different rows. I think to get the best performance you shoud redesign your tabel. Use at last first normal form [1NF], if the app_id is uniq this can be the primary key [which will speed up the quer

Re: How to get a nice schema diagram

2003-10-22 Thread Peter Buri
Hello, i think DBDesigner 4 [ http://fabforce.net/dbdesigner4/ ] is the tool you are looking for! :) burci Tuesday, October 21, 2003, 8:49:31 PM, you wrote: JW> Looking for an open source or commercial tool to help with database JW> visualization for a presentation we are to give. Can't seem