Pelican Parts Forums

Pelican Parts Forums (http://forums.pelicanparts.com/)
-   Off Topic Discussions (http://forums.pelicanparts.com/off-topic-discussions/)
-   -   SQL for Wayne (http://forums.pelicanparts.com/off-topic-discussions/357839-sql-wayne.html)

KFC911 07-19-2007 10:11 AM

Sounds like Wayne is onto something, but I agree that this "smells" more like a corrupted db, etc. than a MySQL architecture issue, based upon my own "end user" experiences. Any issues with MySQL (assuming it hasn't been upgraded/modied lately) would have been there since the git-go, and this performance degradation happened almost "over night" a few weeks back. I know we're probably not helping you Wayne, but it gives us something to chat about instead of politics :)!

slakjaw 07-19-2007 10:35 AM

Ya know, I was going to say this seemed to happen really fast. not a gradual thing at all.

IIRC it started a little over 4 weeks ago. at least for me.

71T Targa 07-19-2007 01:15 PM

Quote:

Originally posted by dhoward
AS400 is now I-Series.
Same OS400 / Same DB400
Work with Active Jobs?

The iSeries is now i5, and OS400 is now i5/OS.

WRKACTJOB? The commands are just a bunch of TLA's... :)

t951 07-19-2007 07:09 PM

I agree, this forum has come to a crawl, it was like someone left the e-brake on.

As of a few weeks ago it got real slow.

Oracle 07-19-2007 09:20 PM

Wayne,
The SQLServer licenses $$$ is not too bad, what's going to be expensive is the internet access. Everytime a database serves out the internet it requires some special licensing from Oracle or Microsoft, their argument is that you can't control how many users will benefit from using the database server (and going with a single application connection argument doesn't fly)
If your database is less than 2GB of space you qualify for the MSDE Edition or Oracle Express Ed. These versions are fully featured they're only restricted to the size and number of CPU.
(please check the fine print and details for each one)

I'm a DBA so I offer you my help, let me know..

Bye
Jasper

71T Targa 07-20-2007 08:41 AM

Anyone else think this started just after the thread telling people how to make their browsers faster by opening multiple connections?

KFC911 07-20-2007 08:59 AM

I did point that out a few days ago (it might have been on another thread). It may or may not be critical, but it's a good suggestion as many times poor performance is a combination of factors.

KFC911 07-20-2007 09:05 AM

Quote:

Originally posted by phred68
Anyone else think this started just after the thread telling people how to make their browsers faster by opening multiple connections?
Yes, I pointed that out on another thread.

Shuie 07-20-2007 11:31 AM

One word:

Oracle

jeffgrant 07-20-2007 02:59 PM

Two words.

******* Expensive.


All times are GMT -8. The time now is 01:08 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0
Copyright 2025 Pelican Parts, LLC - Posts may be archived for display on the Pelican Parts Website


DTO Garage Plus vBulletin Plugins by Drive Thru Online, Inc.