Results 1 to 4 of 4

Thread: I need advice (big data grid/table performance)

  1. #1
    Join Date
    Jun 2009

    I need advice (big data grid/table performance)


    I am projecting new application what has big tables on pages. Something like contacts. (ca 2000-6000 records to view same time; and every record has 10-20 fields to show) I want that all table can be edited (add keyword(s) to every record, note(s), etc) I can filter data in grid. And can fill all column by same value or by some rule. Can edit every record separately. Something like simple version of Excel or Access DB

    At the moment I have app what does almost everything needed (did it with dhtmlX components ; JS/AJAX+PHP), but over 2000 records on page it will be so slow that changing info and saving to server will take 1-3 minutes to wait before anything happens. There is no difference what browser I use. With these dhtmlX components I cant use pagging, because then I cant change all data same time. I can change only data on current page.

    I dont know now how to do application react quicker than now? Should I use C# and ASP technology? Or do Win.Forms Client-Server app? Can any more experienced give advice/hint/tip what techology to use or how to solve this kind problem?

    Sorry my bad English, its not my first language

  2. #2
    Join Date
    Jan 2007
    A little clarification would be useful here. When you perform these bulk-updates, what's actually happening on the back-end? Anything? Are you running any SQL queries? Or are you really just waiting for the browser to update values locally?

    I would presume that you're waiting on some SQL queries. I would also presume that you're running a single query for each row that receives an update, which is the wrong way to do it. I'm not sure tho ... Please clarify!
    Jon Wire

    thepointless.com | rounded corner generator

    I agree with Apple. Flash is just terrible.

    Use CODE tags!

  3. #3
    Join Date
    Jun 2009
    Currently I have test app what shows real data from DB but will not update anything in DB.
    Grid rendering will take most of the waiting time. Updating and server side takes only 10-20% of this delay.
    Currently yes every record update will sent separately to server (but at moment php-script doesnt do anything, sends only response that all is ok).

    Step-by-step (2500 records):
    grid rendering > 2 min (I need to do this because without this grid will update only records visible on screen )
    grid update ca 10-15 sec
    server responses ca 10-20sec

    Sorry my bad English, its not my first language

  4. #4
    Join Date
    Jan 2007
    Is the client-side script making a request for each row that needs to be updated though? That could make things a little sluggish?

    If client-side rendering alone is taking a long time, you may just need to consider alternate means of displaying the table--display a limited number of rows at a time or something. Check up on how much memory your browser is using--maybe you're page/script is consuming so much memory that its generating frequent page faults.

    It's tough to say what else to do, not having thorough internal knowledge of the scripts you're using. One of the main points in using those helper libraries is to avoid having to know what's going on with any detail. If you want to optimize things, you may have to delve in ...
    Jon Wire

    thepointless.com | rounded corner generator

    I agree with Apple. Flash is just terrible.

    Use CODE tags!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center



X vBulletin 4.2.2 Debug Information

  • Page Generation 0.10335 seconds
  • Memory Usage 2,869KB
  • Queries Executed 15 (?)
More Information
Template Usage (32):
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (4)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (73):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates