Sorting Large Data Sets
Nov 5, 2007
I have a table I am populating with data from a DB, and have it
sortable on the client side. When the table exceeds around 300 rows,
I start running into problems with rendering and sorting it. I
started out using Prototype to help with the sorting, but it appears
that this results in a lot of calls to _getElementsByXPath, which are
taking up a large percentage of the rendering time. I believe this
call is occurring as the DOM is being parsed.
What is the general/most accepted manner of dealing with large data
sets (I am expecting some to grow into the thousands) in a table so
that it can be sorted client side? I am thinking of building a
javascript (JSON) object containing the data, and sorting based on
this. Anybody have any thoughts on this approach, or any suggestions
for other ways to approach this?
View 2 Replies
ADVERTISEMENT
Jul 6, 2011
I am in the process of creating a site for real estate listings optimized for a mobile environment. One of the features that is desired would be a google map that loads listings as the user drags. One of the catches to this is that very few listings have included latitude and longitude values. Therefore, every time I need to add a listing to the map I first need to geocode it. Now with a few listings this is not really a big deal. However, the end goal would be to show all listings within the current bounds.Which depending on the zoom level could be anywhere from a hand full to several hundred.owever, when I attempt to load say 100 listings to the map it pretty much freezes and is fairly buggy after wards.
That said I was wondering if there is a better way to handle this. Perhaps submitting the listings as places with a CRON and having markers generated automatically? I am just trying to think how I can achieve this in a way which doesn't kill a mobile phone because it seems impossible considering there could be over 5000 listings in bounds of the map area. The only real solution I have is to only show say 30 or so and use pagination for the next 30 and so one within bounds.The ultimate goals is when the map bounds change ALL listings will show up within that bounds. The way I have currently approached this is that when the user stop dragging the map a asynchronous request pulls in ALL listings within bounds as an XML those full addresses are geocoded and added to the map. However, this is wrecking havok on the browser and I am not even going to try it in a mobile environment considering its dragging a desk top down. I'm thinking this is less and practical and pagination has to be used but perhaps someone out there has dealt with a similar objective.
View 1 Replies
View Related
May 22, 2009
We are using jQuery JavaScript Library v1.3.1 for paging and sorting purposes. This library is working fine when we are loading smaller
data sets (<1000 records) on the page. However, when data set starts getting large (>3000 records), the initial page gives a script loading
error and the page does not load at all.
View 1 Replies
View Related
Apr 5, 2007
Here's the situation: I have a simple php file which retrieves data from a
mysql database and displays it in a table. However, the number of records
has gotten so large that retrieving all the data takes a lot of memory and
the browser freezes.
I been googling for a solution and some1 mentioned something called live
scrolling where the data is retrieved only when you scroll up or down.
Since am just an amateur and not familiar with XML, XSL, etc; can any1
recommend some link where i could find some JS script with such a feature?
one that's easy to get started with if possible...
View 4 Replies
View Related
Oct 29, 2010
I have a coldfusion data component that receives two arguments and runs a stored procedure and returns a large data set. I want to use a textbox with autocomplete its data is that result set. I do not want to convert the result set to an array for performance.
View 1 Replies
View Related
Nov 13, 2006
I mainly do LAMP programming, and as such don't have much experience with JavaScript.
I'm looking for a simple function that will allow the user to reorder search data gotten from a database and displayed in a table.
Meaning, the user clicks on one of the column headers, and js automatically resorts the results. I've seen some stuff online, but none of it seems to really work.
Can anyone point me to something in the right direction?
View 1 Replies
View Related
Dec 5, 2010
I was looking for JQuery Grid which will help me more than 1000 - 2000 records. I mainly need search and paging .
View 1 Replies
View Related
Oct 11, 2010
I am using Ajax to send a large text box to a server script, however, when the textbox has a lot of data it fails. Is there a better way for me to do this? Here is my code.
Code:
<script type="text/javascript">
function testmail()
{
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
[Code]...
View 7 Replies
View Related
Dec 13, 2011
I've been using localStorage to store a large amount of data (> 5mb). I know that most browsers limit localStorage to 5mb. However, on the specification site it states,
Quote:
User agents may prompt the user when quotas are reached, allowing the user to grant a site more space. This enables sites to store many user-created documents on the user's computer, for instance.
Is this available yet? If so, how would I use it?
View 3 Replies
View Related
Dec 9, 2010
I have this source code (I get "data" via AJAX / JSON and it has the properties person.id and person.lastname).
[Code]...
I searched for sorting them in an alpabetical order. I saw solutions, fetching the whole data, but I am rendering the HTML ul list, so perhaps there are better ways to sort it? Or is it necessary, first to push all the li's to the ul? Isn't there a jQuery basic function for it?
View 3 Replies
View Related
Oct 13, 2009
I'm requesting a very large JSON dataset for a table via AJAX and I'm building it on the fly with JQuery. What would be the most efficient way to build it?
View 2 Replies
View Related
Feb 1, 2009
I'm building an online auction system. Each participant will be allowed to post one bid per minute for about 3 hours. Each person's "bid history" must remain visible to him during the entire auction in a scrollable list, and this list must be sorted from high to low bid. These auctions will have upwards of 10,000 bidders and the server will be seriously stressed in dealing with so many bidders posting another new bid every minute. Therefore I want to alleviate any additional stress on the server by storing and sorting each bidder's "bid history" in his own browser -- perhaps in a cookie or maybe there is a better javascript-based data storage container available for this purpose ... ?
This seems like a natural application for javascript because of the fact that only the individual bidder needs to see his own list of submitted bids -- sorted from high to low -- and I'm hoping that javascript can be employed to do this.
1- A bidder enters his bid into a form (example 12345.67) and posts the form to the server;
2- Javascript grabs the posted value and appends it to the cookie or whatever container is storing the bids in the browser;
3- Javascript re-sorts the values and displays them again, perhaps in an iFrame or maybe in another kind of scrolling list on the main page.
Note that these bids will NOT be placed in ascending or descending order (this auction is different from most) and this means the values must be re-sorted each time a new value is posted -- so they always appear sorted from high to low in the list.
View 12 Replies
View Related
Oct 1, 2009
I am having a little problem trying to show a loader (An animated GIF) while some request to a database happens. I have a page where the user selects a YEAR and when they select it with AJAX I perform a request to a database to get all the values for that specific year.
The problem is that there is a lot of information (4000+ records) that I need to query and show in a table (Actually I didn't use a table I use DIVs that look like a table), and when the user selects the year the webpage freezes for about 5 seconds and then it loads all of the data.
Is there a way to sort of show an image loader gif while the data is being gotten? I tried putting the loader image in the DIV container while no year is selected and then once the request is done, I substitute the DIV container's contents (The image loader) for the data from the database.
[Code]...
View 1 Replies
View Related
Sep 2, 2007
A group of select inputs with identical options When an option is selected from 1 dropdown it is removed from the others (unless its a blank one)
Now I'm reusing the script in another application that has multiple sets of dropdowns (but only 1 that the script needs to apply to) It works fine except, all the options get jumbled up - in all the dropdowns.
The script is a little beyond my level of javascript - I think largely because it doesn't use 'sensible' variable names so its quite hard to follow. How can I modify the script to not mess up the order (most importantly of the other dropdowns that aren't having elements removed and added) Code:
View 2 Replies
View Related
Jul 23, 2005
I'm not sure if this is a style sheet issue or a Javascript issue.
I'm trying to work out a new design for my software's control panel.
The idea is that there are images on the left that you click and that
as you do, DIVs with option links appear and disappear on the right.
Because I want each of the DIVS to appear in the same place, I use
Javascript to set their padding and their height to 0px when they are
invisible. This is working the way I wish in Netscape 7.1 but it is
not working the way I want in IE. Can anyone give me a hint about why?
View 7 Replies
View Related
Jan 20, 2005
Basically, if a value is a member of all the arrays passed to the function, this function will add that value to a response array. The function returns the response array.
/**
* Return an array of members existing in all argument arrays.
*
* @param aSet(n) JSArray.
*/
function getSetIntersection(aSet1, aSet2) {
var temp = [];
var offset = arguments.length - 1;
var response = [];
for (var i = 0; i < arguments.length; i++) {
temp = temp.concat(arguments[i]);
}
temp.sort();
/*
* The goal is to find an ordered sequence of n identical members of temp,
* where n = arguments.length. For this, we just need to check the start
* and end points of the sequence, and if they match, push them on to the
* response array.
*/
for (var i = 0; i < temp.length - offset; i++) {
if (temp[i] == temp[i + offset]) {
response.push(temp[i]);
i += offset;
}
}
return response;
}
The assumption is that no member of the original arrays is repeated. I'd welcome a sanity check for that.
View 15 Replies
View Related
Jul 23, 2005
I've been trying to create two different sets of required fields in
one form and to use a
radiobutton as sort of a switcher between these sets.
In my HTML form there are two radiobuttons with values 'Via Email' and
'Printed Brochure'.
If a user checks 'Via Email' radiobutton, he/she has to fill out Email
and Name fields
only, if it's radiobutton 'Printed Brochure' is checked, a user has to
fill Email, Name
and ALSO Address field.
I use this script below, but it doesn't seem to work, and I can't get
it why.... Code:
View 14 Replies
View Related
Oct 14, 2009
I have two element sets: $(".contentBox") and $(".referencesImage"). How can I join the elements in this sets? I would like to join the sets, since I'm adding the exact same hover function on both element
[Code]...
View 5 Replies
View Related
Jul 26, 2009
I am having trouble getting values from multiple radio sets. I know it is probably elementary, but this is the code I am using:
Radio Set 1
<label>
<input type="radio" name="radSafe1" value="AR" id="radSafe1" onClick="SetFocus('1_1')"/> </label> <label>
[Code].....
Well, I am using the alert function to test the values, but no matter what is checked, even if none are, the values for both of them are always "AR".
View 5 Replies
View Related
May 3, 2010
have been trying to get the rotating pictures to work. I am using dreamweaver 8. If I put one rotator on the page it works fine but when I add the second they both don't work. here is my page code
[<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
[code]....
View 5 Replies
View Related
Apr 29, 2011
When the return value of a function is another function like:
Code:
The normal method I've seen to invoke the returned function is:
Code:
In, JavaScript closure for dummies, in the 6th example the returned function is invoked using double brackets like:
Code:
This is working perfectly in firefox. This is the 1st time I'm seeing a function call like this.
Does this work in all browsers?
View 5 Replies
View Related
Jul 23, 2005
For instance, one set is:
<body onload="blinking_header()" onunload="stoptimer()">
Another set is:
<body onload="writemsg()" onunload="stoptimer()">
They represent two functions. How to place them in the <body> tag?
View 1 Replies
View Related
Jan 23, 2011
I developed a plugin which loads some content via AJAX. Every time the content is loaded I need to bind to certain elements ( let's say the elements with 'bar' as classname ) the mouseover and mouseout elements. I achieved it by using the ' live() ' instruction.Now my problem comes when I need to scan every element which has 'bar' as classname and do some calulcations on it (they are over 600). I tried to do like this
$container.find('.bar').live('customevent', function()
{
// do some stuff
});
then, once the contents is loaded
...
$container.find('.bar').trigger('customevent');
but this will cause the browser to carsh ( I think because jQuery is scanning over than 600 elements)
View 1 Replies
View Related
Mar 25, 2009
I have 3 radio buttons and based on which is clicked I want to write html to a div. So far nothing is happening and it seems that the onclick is not being done at all or tried.
This is what I have:
Code:
<script type="text/javascript">
<!--
function getAmt(ss){
if(ss == "fy"){
[Code]....
View 3 Replies
View Related
Jul 11, 2011
I need another few more sets of the triple drop down menu same as the below script... (Scenario: creating like a online shopping order form, where customers can have multiple orders.)
<script type="text/javascript">
/*
Triple Combo Script Credit
[code].....
View 14 Replies
View Related
Feb 5, 2009
I'm using Minitabs plugin. It works great for me, but I just can't have multiple tab sets on the same page. This is the JS:
Code:
jQuery.fn.tabs = function(speed,effect) {
id = "#" + this.attr('id')
$(id + ">DIV:gt(0)").hide();
[Code].....
View 5 Replies
View Related
