 |
|
01-05-2009, 01:59 PM
|
|
|
A-well-a bird, bird, bird, the bird is the word!
|
Re: LootDB - check out and contribute
Quote:
Originally Posted by Vahan
*UPDATE*
January 4th, 2009
LootDB item search is much faster now after database upgrade.
I have reindexed the main collector database and optimized SQL queries - results should be sorted by relevance now, and ten-fold faster. LootDB currently runs on Quad Dual Core 3Ghz Xeon server with 8Gb RAM - beside clustering there isn't much room for upgrades ;)
Search queries are quite complex as several db tables are searched/joined/sorted, with two of them having 2mln+ rows.
|
Yup, much faster now. Could go make a cup of tea and still not have the page load before (ok exaggeration, but you get the point  ). |
|
|
|
01-06-2009, 01:05 AM
|
|
|
A-well-a bird, bird, bird, the bird is the word!
|
Re: LootDB - check out and contribute
Quote:
Originally Posted by Niber
Cup of tea.. haha, foreigner!
|
I'm British, what can I say, Tea and Hot chocolate are much nicer than Coffee.  |
|
|
|
|
01-06-2009, 07:13 AM
|
|
|
LootDB.com
Character: Vahan
Server: Runnyeye
Posts: 41
|
Re: LootDB - check out and contribute
Phrozen, can you elaborate what are you searching exactly and what's your teapot's brand/model? 
Is this slow search originating from the search on the frontpage or the advanced search page?
Last edited by Vahan; 01-06-2009 at 07:16 AM.
|
|
|
|
|
01-06-2009, 10:36 AM
|
|
|
A-well-a bird, bird, bird, the bird is the word!
|
Re: LootDB - check out and contribute
Quote:
Originally Posted by Vahan
what's your teapot's brand/model? |
This Kettle, so I cheat in the fact it keeps boiling it every like 10 minutes :P
And it was always pretty slow for me searching from the Front page for a particular item, Say searching for "Charm of" to see the Avatar charms, and it'd take a good ~30-40seconds to load for me, whereas EQ2LL was almost instant, but yours is a hell of alot better now, it's almost on the same terms as EQ2LL, so worth using now  |
|
|
|
|
01-07-2009, 10:39 AM
|
|
|
Unpatriotic Rotten Doctor Commie Rat
Character: Lessingz
Guild: Remnant
Server: Najena
Posts: 3,284
|
Re: LootDB - check out and contribute
Quote:
Originally Posted by Anap KaSplat
stored procedures ftw.
|
How do stored procedures alone improve performance? They just execute the same sql that you could have executed otherwise.
__________________
alone she sleeps in the shirt of man
with my three wishes clutched in her hand |
|
|
|
|
01-12-2009, 10:51 AM
|
|
|
Visitor
Character: Zexualhealin
Guild: Archon
Server: Crushbone
Posts: 26
|
Re: LootDB - check out and contribute
I can only speak for Microsoft SQL but I believe mysql has the same... stored procedures have cached Execution Paths assuming that you don't use concatenated SQL in your stored procedure.
__________________
Atomicfury - Crushbone
|
|
|
|
|
01-12-2009, 11:59 AM
|
|
|
Unpatriotic Rotten Doctor Commie Rat
Character: Lessingz
Guild: Remnant
Server: Najena
Posts: 3,284
|
Re: LootDB - check out and contribute
Cached execution paths is comparable to, let's say, compiled code vs interpreted code? I only know oracle first-hand, and oracle does that internally, freeing the user from having to use procedures for max performance.
__________________
alone she sleeps in the shirt of man
with my three wishes clutched in her hand
|
|
|
|
|
01-16-2009, 03:49 PM
|
|
|
LootDB.com
Character: Vahan
Server: Runnyeye
Posts: 41
|
Re: LootDB - check out and contribute
*UPDATE*
January 16th, 2009
Registered and logged in users can now filter item/mob/zone info by a specific class.
|
|
|
|
|
11-17-2009, 06:59 AM
|
|
|
Regular
Character: Vulkan
Guild: Last People of the Dragon
Server: Runnyeye
Posts: 167
|
Re: LootDB - check out and contribute
is lootdb down? havent been able to access in several days.
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
|
|
