Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
As some of you know, I have been doing most of the development of Anthem.NET for the last year. Anthem.NET is an open source Ajax library for ASP.NET sites. It works with ASP.NET 1.1, 2.0 and Mono. BV Software uses the core library in BVC5. I'm also a fan of the Yahoo! User Interface Library. I recently wrote an article demonstrating a mashup between Anthem.NET and the YUI AutoComplete control. Since the demonstration uses a BVC5 store, I thought there might be some interest here. http://structured-solutions.net/AutoSearchMashup |
|
|
|
|
|
|
Rank: Member
Joined: 5/24/2004(UTC)
Posts: 4,147
|
Nice, Andy! Perfect timing, since I was just about to look into doing this myself. Thanks! :) |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
I was hoping you would see this and work your magic. I hope you can share what you come up with. Let me know if you have any questions. |
|
|
|
|
|
|
Rank: Member
Joined: 6/6/2005(UTC)
Posts: 483
|
That looks really cool.
I want one.
Bob Noble
|
|
|
|
|
|
Rank: Member
Joined: 11/6/2003(UTC)
Posts: 1,903
|
Andy, what kind of hit on the server is this?
I could see a lot of sites benefiting from it, on some of them I could also see it making a whole lot of calls. |
Noah |
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 2,136
Was thanked: 1 time(s) in 1 post(s)
|
Noah,
I have not done any measurements, but here are my thoughts...
The YUI AutoComplete control will cache results locally (in the browser) so that if one customer searches for "red" then "green" and then "red" again it will not make a call to the server the second time they type "red".
You can also adjust the delay before the control makes a call to the server (it defaults to .5 seconds).
When the query is sent to the server, my sample implementation limits the number of results to match the maximum number that the control will display (the default is 10). I have not looked at the stored procedure, but I'll guess that this limits the amount of work that the db performs.
I don't do this in my sample, but you can also cache results on the server so that popular queries (i.e. "red") are returned without hitting the database.
It would not be hard to add some simple instrumentation. I'd love to see some test results if someone puts this into play. |
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.