Discussions

 View Only
  • 1.  Do unused tables related to currently used tables cause functionality problems?

    Posted 21 days ago

    I have 25 tables in one app. 22 are unused tables.  They were previously used to track data but have since been migrated to another program.  My currently used tables still have relationships to a majority of these tables that are not updated.  Do these tables effect functionality for the active tables apart from the obvious missing data? Does it slow the program down?  Thanks!



    ------------------------------
    HP
    ------------------------------


  • 2.  RE: Do unused tables related to currently used tables cause functionality problems?
    Best Answer

    Posted 21 days ago

    Others might feel differently but to answer your question specifically - yes, it affects the overall load of the app and functionality - but the amount is probably so miniscule and minute that you could go 10 years and forget that they're there. When your app is loaded Quickbase has to summon those tables, and with your relationships it will need to evaluate that data and determine any lookups and summaries that need to be assessed, but again, it's probably so small that it doesn't matter. There is very little impact if you leave them, and probably almost nothing to gain if you're considering removing them. 

    The caveat to the above is if your 'used' tables are massive or taking up a lot of app bandwidth - or if these now defunct tables are huge then it might be slightly different - but if across the board it's just an average table - you can probably forget they're there. 



    ------------------------------
    Chayce Duncan
    ------------------------------



  • 3.  RE: Do unused tables related to currently used tables cause functionality problems?

    Posted 20 days ago

    I'd agree with Chayce from my experience. Any performance concerns are likely negligible, but that entirely depends on the complexity of your specific app and record volume.

    If you do want to remove them to clean up after your future-self and others, you could open a Support Ticket to request a copy of the app to have as an "archive" prior to removing the tables from the live app. Then, restrict access to the archive as necessary to avoid confusion.

    Alternatively, you could go into table settings and hide from the table bar to give the appearance of a slimmer app that may be a bit easier to navigate. And make the deprecated tables not searchable for the most part.

    Also be mindful of any cross-app relationships to your 25 table app. Those relationships require the linked apps to boot up too.

    Brian Cafferelli has written several performance related blog posts that may be worth your time. It'd be interesting if you used the Performance Optimizer several times to benchmark your app's current state, then remove the tables and re-run the Performance Optimizer to compare results. But, my guess is that you won't really notice a difference.



    ------------------------------
    Brian Seymour
    ------------------------------



  • 4.  RE: Do unused tables related to currently used tables cause functionality problems?

    Posted 20 days ago

    Thanks!  This is good to know.

     

    Helen Peynado
    Technical Writer 1 | Pilot Manufacturing
    P: 503.885.7567  

    LAM RESEARCH
    4650 Cushing Pkwy, Fremont CA 94538 USA
    lamresearch.com

     


    LAM RESEARCH CONFIDENTIALITY NOTICE: This e-mail transmission, and any documents, files, or previous e-mail messages attached to it, (collectively, "E-mail Transmission") may be subject to one or more of the following based on the associated sensitivity level: E-mail Transmission (i) contains confidential information, (ii) is prohibited from distribution outside of Lam, and/or (iii) is intended solely for and restricted to the specified recipient(s). If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify the sender and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.

    Confidential – Limited Access and Use