New Forum "Feature"...

[motion]

3 words: mac

[cool_chick]

Just curious, is there a dialog returned with a killed search?

[SlowToady]

Have you thought about trying a different database?

[rattlsnak]

Originally Posted by motion

3 words: mac

Yeah, then he wouldnt have ANY connectivity so he wouldnt get any searches returned.

Are you using WAMP?
I would think you're using the %'s on either end of the search queries?

To be able to search for words anywhere in a data field, you need to use the Boolean AND condition in the SELECT statement to link together multiple LIKE conditions.

SELECT * from xxxxx WHERE title LIKE '%xxxxx%' AND title LIKE '%xxxxxx%'

[kstar]

One of these Xserves with Quad Xeons and OS X (Apache) server would do the trick.


http://www.apple.com/xserve/

Unless you don't like Unix and just absolutely have to run Windows Server 2003.

FWIW.

Best,

Kurt

[HardDrive]

Mac users: Keepin' the Koolaid flowin'

[kstar]

No Kool-aid needed.

The XServes are competitively priced (even cheaper than many comparably equipped machines) and OS X Server can run all the *nix apps and has a great UI if you need that.

Like I said, if you don't like Unix and prefer Windows Server 2003 (what these forums are running on) then that's cool too.

FWIW.

Best,

Kurt

[TechnoViking]

Does this mean that certain searches are now impossible? Or if I try again, will it be shorter the second time, and thus will work?

[Dantilla]

Wayne, you brought these problems on yourself by hosting a Porsche site.

You wouldn't have these issues if you had a site for Buick Skylark fans.

[legion]

If reliability, scalability, and uptime are critical, there is nothing that beats DB2 on zOS. However, a few million on hardware and another few million on software (license per year) is probably out of the question for this BBS.

DB2 on Unix is a distant second in the above criteria and cost...

[SlowToady]

Any one of these would also do the trick

SUN Rack servers

Or one of these....

IBM POWER servers

These have a pretty good reputation.....

HP Integrity OpenVMS servers

[cool_chick]

Wayne, all you need is this:



Hehe, couldn't resist.

[legion]

Do you have access to the source code for vBulletin? (As an aside, what language is it written in?) If so, you should be able to modify it to work with any DBMS.

[MysticLlama]

We had a similar problem on our webserver software with a memory leak. The process would hang, even though there was plenty of memory, process time, and disk time free.

We were stuck on the software, since the chunk that was causing it was a necessary evil from our software vendor, closed source, and untouchable.

We invented a similar watchdog sort of process to cycle the thing when it would do that. It ended up solving the problem about 99% of the time, so we ended up just calling it good.

Sometimes the effort required to chase it to that last 1%, if even possible, isn't worth it.

I think the only other thing that might be worth a shot is maybe mySQL on Linux on a test machine just to see if it has the same bug. I prefer Windows 2003 personally too, but I have a friend that does a lot of work with many different DBs, and he's always said that mySQL on Windows doesn't run quite the same as it does on Linux, unlike some of the other things that work the same on either OS.

The other thing we ran into was a perfectly good query that acted up just because of the version we were running at the time of Informix. When we tried to do a DATE -1 query to come up with yesterday's date (which worked on Access, MS SQL, mySQL, etc.), it would start something off that would make the DB just fall dead about 2-3 hours later. Reproduced it every time once we figured it out..... which took forever.

Still, sometimes something like simple process recyclers/killers solve the problem the easiest way.