Malcolm Greene wrote:
> Ricardo!
>
> Holy #&!()! How big are your tables and how long does this process take
> to run?
>
Ok, got the numbers. The tables are 122,406 recs, 62,610 recs, and
75,117 recs., and the time it takes to perform the queries I posted is
10 seconds including the writing of a 3,000 line excel sheet.
This system is not mine, it is a semi canned system, the tables are many
times not normalized and are generally kind of a disaster. My app
provide reports and functionalities that management needs and the canned
system does not provide.
And the structures would be :
---------------------------------------------------------------------------------
[] [smallint] NOT NULL ,
[] [smallint] NOT NULL ,
[] [int] NOT NULL ,
[] [char] (3) COLLATE Modern_Spanish_CI_AS NOT NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NOT NULL ,
[] [smallint] NOT NULL ,
[] [int] NOT NULL ,
[] [smallint] NOT NULL ,
[] [datetime] NULL ,
[] [money] NULL ,
[] [money] NULL ,
[] [money] NULL ,
[] [smallmoney] NULL ,
[] [smallmoney] NULL ,
[] [smallint] NULL ,
[] [char] (3) COLLATE Modern_Spanish_CI_AS NULL ,
[] [money] NULL ,
[] [datetime] NULL ,
[] [money] NULL ,
---------------------------------------------------------------------------------
[] [smallint] NOT NULL ,
[] [smallint] NOT NULL ,
[] [int] NOT NULL ,
[] [datetime] NULL ,
[] [datetime] NULL ,
[] [int] NULL ,
[] [int] NULL ,
[] [int] NULL ,
[] [int] NULL ,
[] [int] NULL ,
[] [int] NULL ,
[] [char] (60) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (30) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (20) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (15) COLLATE Modern_Spanish_CI_AS NULL ,
[] [smallint] NULL ,
[] [decimal](11, 0) NULL ,
[] [money] NULL ,
[] [money] NULL ,
[] [money] NULL ,
[] [money] NULL ,
[] [money] NULL ,
[] [smallmoney] NULL ,
[] [smallmoney] NULL ,
[] [smallmoney] NULL ,
[] [smallmoney] NULL ,
[] [smallmoney] NULL ,
[] [decimal](7, 4) NULL ,
[] [char] (60) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (60) COLLATE Modern_Spanish_CI_AS NULL ,
[] [smallint] NULL ,
[] [smallint] NULL ,
[] [int] NULL ,
[] [datetime] NULL ,
[] [char] (8) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (8) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[] [money] NULL ,
[] [char] (8) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[] [datetime] NULL ,
[] [int] NULL ,
[] [smallint] NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (3) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (60) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (8) COLLATE Modern_Spanish_CI_AS NULL ,
[] [datetime] NULL ,
[] [char] (10) COLLATE Modern_Spanish_CI_AS NULL ,
[] [datetime] NULL ,
[] [int] NULL ,
[] [smallint] NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (3) COLLATE Modern_Spanish_CI_AS NULL ,
[] [datetime] NULL ,
[] [int] NULL ,
---------------------------------------------------------------------------------
[] [smallint] NOT NULL ,
[] [smallint] NOT NULL ,
[] [int] NOT NULL ,
[] [smallint] NOT NULL ,
[] [smallint] NOT NULL ,
[] [smallint] NOT NULL ,
[] [char] (3) COLLATE Modern_Spanish_CI_AS NOT NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NOT NULL ,
[] [smallint] NOT NULL ,
[] [int] NOT NULL ,
[] [smallint] NOT NULL ,
[] [int] NULL ,
[] [datetime] NULL ,
[] [datetime] NULL ,
[] [smallint] NULL ,
[] [money] NULL ,
[] [money] NULL ,
[] [smallint] NULL ,
[] [smallint] NULL ,
[] [smallint] NULL ,
[AnxRel] [int] NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[] [datetime] NULL ,
[] [smallint] NULL ,
[] [smallint] NULL ,
[] [smallint] NULL ,
[] [char] (3) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[] [smallint] NULL ,
[] [int] NULL ,
[] [char] (3) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[] [smallint] NULL ,
[] [int] NULL ,
[] [char] (3) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
[] [smallint] NULL ,
[] [int] NULL ,
[] [int] NULL ,
[] [decimal](11, 0) NULL ,
[] [decimal](11, 0) NULL ,
[] [datetime] NULL ,
[] [char] (60) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (8) COLLATE Modern_Spanish_CI_AS NULL ,
[] [datetime] NULL ,
[] [char] (10) COLLATE Modern_Spanish_CI_AS NULL ,
[] [char] (40) COLLATE Modern_Spanish_CI_AS NULL ,
[] [int] NULL ,
---------------------------------------------------------------------------------
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
