d the server is a faster machine then mine.
They run in 8 minutes on my test server , about 4 minutes each. Printing to
a PDF driver.
On the Production Server they take HOURS to run and print.
Any ideas...
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROT
no it is dedicated to the DataWarehouse Report Processor.
runs one report at a time from a ReportQueue.
both have a local host.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]]
Sent
one other thing , the girl that made them did it with an Access database
copy of the warehouse.
I changed the connection to the real Datawarehouse.
if that makes any difference
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message
queue
and runs the reports one at a time and emails them out.
Outlook Express is running in order to email the PDF files to the recipient.
I can understand it being SOME slower , but not hours slower.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED
oh and my test server is my PC , so I had all kinds o crap running
on it at the same time.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 1:57 PM
thanks. we are doing the data load today and will upgrade the MYODBC to
3.51 before we do it. This will be a good test as the load takes 6 hours
on the current version.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From
It doesn't run over the network.
The reports are requested from a website , and a record is inserted into the
ReportQueue.
And then the reports are run local on the Production machine and then
emailed to the recipient.
At this time only 2 people order reports.
Mary Stickney
TAG-TMI
amp; sFromDate & _
" AND AdminCoverage.InitialPremiumDate <= " & sThruDate & _
" AND TaxID='" & FixSQLString(rs!taxid) & "'" & _
" ORDER BY AdminHierarchy.WritingAgentSlot,AdminCoverage.CoverageId," & _
" AdminCover
select * from forms_data_recs
where fdr_form_id='37' and ( fdr_ff_id ='190' and ( fdr_value like
'%keith%' ))
OR ( fdr_ff_id = '192' and (fdr_value like '%public%' ))
order by fdr_date,fdr_id
-Original Message-
From: Keith Clay [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 1
,RegionCode,FirstYearSales,SecondYearSales,ThirdyearSales,Perc
entOfCases,producerid,distributioncode,PremiumsInForce) VALUES
(080323288,'PIC' , '2000','2001', '2002',
'3/30/2002','0B917','N0305',1,'7B',0,0,18.59,50,'0
tring(sDistributionCode) & "'"
Call SendToDwDb(sSql, rs5)
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 11:11 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: null
That is really odd,
ok , but I have now just programmed around the error
to meet my deadline...
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Re: RE: null
Mary,
Wednesday, August 14, 2002, 7:23:47 PM,
It doesn't suport alot of differnt things
it dosent have store procedures , dosent have a complete SQL command set...
I am using it becasue I am being forced to...
-Original Message-
From: Elizabeth Bogner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 9:25 PM
To: [EMA
I have been doing speed tests the same query ran on MYSQL took 45
minutes
on MS-SQL it took 11 minutes..
yes you do get what you pay for
-Original Message-
From: Francisco [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 8:47 AM
To: Mary Stickney; Elizabeth Bogner
What exactly is Trolling
I find MYSQL to be slow , sorry if that doesn't met with your approval.
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:15 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not
L PROTECTED]]
Sent: Friday, August 16, 2002 9:21 AM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Hi Mary,
I am not specially against or pro MySQL, Microsoft SQL
Server, Oracle or any other database. Teams make their
choices based on the projec
]]
Sent: Friday, August 16, 2002 9:25 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: RE: MySQL vs. Oracle (not speed)
Not to open a can of worms here, Mary, but I'd love to know exactly how you
got those results, since they basically contradict every known benchm
I did crash the MYSQL server the other day...
I am currently looping thru and getting the sales agent by agent.
I tried to do the query for all 804 agents at one time and after an hour and
a 1/2 and still not being done
decided against doing it that way.
next I decided I should have a table al
),
KEY LobIdIndex (LOBID)
);
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:15 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Mary Stickney wrote:
> I have been doing speed tests the same query ran
I did send in my query the day I joined this list and the table
structures.
I just did again...
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:47 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed
Oracle (not speed)
what query was it may I ask ?
Tom
- Original Message -
From: "Mary Stickney" <[EMAIL PROTECTED]>
To: "Francisco" <[EMAIL PROTECTED]>; "Elizabeth Bogner"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, Augu
speed is of the utmost importance ,
I can't have a client run a report and wait 2 days for it to finish.
-Original Message-
From: Aron Pilhofer [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 9:46 AM
To: Mary Stickney; [EMAIL PROTECTED]; Francisco; Elizabeth Bogner;
[
;ProductIdIndex;15;AdminCoverage.ProductId;1
1;
;tempsap;ALL;10019;
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:21 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed
yes I do
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 10:37 AM
To: Mary Stickney; Francisco; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Do you have an index on AdminProducer.taxid and on
Mary Stickney; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Could you please send also tempsap ?
Thanks and regards,
Jocelyn
- Original Message -
From: "Mary Stickney" <[EMAIL PROTECTED]>
To: "Mark Matthews" <[EMAIL PROTECTED]&
aving problems with MySQL there
is an entire list of people who are willing to offer support for free. Post
your query and some table information and let's see if we can clear up your
performance issues.
John Griffin
-Original Message-----
From: Mary Stickney [mailto:[EMAIL PROTECTED]]
Se
rosoft seems to always be
plaiged with performance problems. Insulting someone will not help convert
them to MySQL it will drive people away.
Anyway enough of my rant...
Serge.
On Fri, 16 Aug 2002 09:46:44 -0500
"Mark Matthews" <[EMAIL PROTECTED]> wrote:
> Mary Stickney w
incidentaly... Primary keys cant not be made on most of these tables due to
the fact that
the farther back in time you got the more screwed up the data is...
Fields have been added and they did not have the info to fill in the
blanks...
-Original Message-
From: Mary Stickney [mailto
looks to me like I can only make indexes on fields that are not null...
this one is not , not null
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:34 AM
To: Mary Stickney; Mark Matthews; [EMAIL PROTECTED]
Subject: Re: MySQL vs
no I am using myisam it was just a limitation of DBTOOLS
I am getting it done using alter table
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Van
Sent: Friday, August 16, 2002 1:06 PM
To: Mary Stickney
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL
it was a limitation of the DBTOOLS table manager... I am indexing right now
using alter table...
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:08 PM
To: Mary Stickney
Cc: Jocelyn Fournier; Mark Matthews; [EMAIL PROTECTED]
Subject: Re
back.
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:48 PM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
Hi Mary,
My opinion:
MySQL forums are open to every one to said about him MySQL
pro
for reports only
-Original Message-
From: Gelu Gogancea [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 2:14 PM
To: Mary Stickney; Elizabeth Bogner; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
...in this case...is very "sad".
You use this query t
ok fixed thoes every little bit helps... I hope.
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 1:00 PM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: Re: MySQL vs. Oracle (not speed)
I also noticed the field where you make the
E-mail)
Subject: RE: Query Question
I suppose I should have specified that I would not be able to filter by
Data1
> -Original Message-
> From: Mary Stickney [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 19, 2002 11:52 AM
> To: Luc Foisy
> Subject: RE: Query Question
select hostid,patch.patchnumber from host
left join patch on host.hostid = patch.hostid
where patchnumber isnull
-Original Message-
From: Ajay Patel - SunService [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 2:27 PM
To: [EMAIL PROTECTED]
Subject: help with a query
I am
you cant update from is NOT supported
-Original Message-
From: Jakub Mach [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:15 AM
To: Mysql
Subject: SQL - Update problem
Hi,
how can I do sql command like this:
update sekce set pocet = count(*) from odkaz where od
the join syntax is what is differnt between Access and MYSQL.
in MS-SQL = indexs will be used on tables mentioned in the JOIN clause
and they will not in MYSQL
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:40 AM
To: [EMAIL PROTEC
I reported him already... to [EMAIL PROTECTED]
[EMAIL PROTECTED]
and several others..
also wrote back and asked if he thought I was a complete idiot...
-Original Message-
From: John Wards [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:49 AM
To: [EMAIL PROTECTED]
gentid (WritingAgentId),
KEY writingagentslot (WritingAgentSlot)
);
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:11 AM
To: Mary Stickney
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: MS Access and myS
HE ALREADY DID FROM PREVIOUS EMAILS TO MY ACCOUNT... I HAVE A WEB PAGE AND
THEY
ARE MINING EMAIL ADDRESSES.. DUH
SAME BACK AT YOU
-Original Message-
From: Kenneth Hylton [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 11:29 AM
To: 'Mary Stickney'; John War
that would be because b.name is inside the ' ' and it is taken as a
constant.
-Original Message-
From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 11:10 AM
To: [EMAIL PROTECTED]
Subject: like problem
i need this consult
select a.name from table1 a, table
ok try this
select a.name from table1 a, table2 b where a.name like
'%'+ b.name + '%';
-Original Message-
From: Jorge Martinez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 11:48 AM
To: Mary Stickney; [EMAIL PROTECTED]
Subject: RE: like problem
ye
Short answer YES you have to have them
why because 2002-08-29 = 1965
-Original Message-
From: Johnny Withers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 1:30 PM
To: [EMAIL PROTECTED]
Subject: DATES and WHERE
I'm a bit confused here.. dates are not my strong point..
I
44 matches
Mail list logo
