At no time I have said that you should put it everything into 1 table, it is absurd. You should analyze the design of her database.
Without knowing the design of the tables and the data that you need to obtain cannot give a great help. Best Regards ========= || ISMAEL || ========= ----- Original Message ----- From: red_october2009 To: [email protected] Sent: Thursday, August 18, 2011 12:56 PM Subject: [firebird-support] Re: Stumped on SQL Indexing/Bad Plan-ing Just to close off this case, the final SQL that SET was looking at is "slow-ish" because it has to make at least 2 hits to the DB (maybe even 4?) because at least 2 of the fields are BLOB SUB_TYPE 1 fields, which I have learned require multiple hits to the DB. Without those fields included in the field list, the query is < 1s. I need to include those fields and the slower response time is tolerable if I explain it to my customer. -- Side note -- During my 22 years of experience, I have had excellent response times ( < 1s) on all properly made queries, using multiple tables and JOINs of various kinds, on both/either VARCHAR() AND INTEGER fields, in any/all the major RDBMSs. To stuff everything in 1 table defeats the purpose of using an RDBMS. It's not "wrong", but, just not what RDBMS was intended for. [Non-text portions of this message have been removed]
