Post reply

is SQL compression possible?

  • May 30, 2006 at 7:13 am

    #190713

    i connect to the server directly, without any custom written server between.

    the application was designed to work on LAN and it was ok , suddenly it has to work on

    internet and now its not ok, because even if the query's are running smoothly, the results are shown slowly. I need a way to limit the number of results

    A. I should use paging ... but that means redesigning all the SP and code inside the application

    B. IF its possible .. some kind of commpresion, text data should be commpressed very well, i need a way to compress my results, send them over the internet and uncompress them in my application, but i dont know how to do this on SQLServer level. maybe some extended procs

    have you ever confronted with this problem? found any solution?

  • May 30, 2006 at 2:01 pm

    #640765

    could it be that your procedures are doing SELECT * FROM SOMETABLE without a WHERE clause to limit your results? so you end up getting the whole table instead of just relevant rows? ie SELECT * FROM SOMETABLE WHERE ID=7 is much more fficient, if you know you can limit your results;

    also if you just needed the top 1o or something, you can limit it that way as well:

    SELECT top 10 * FROM SOMETABLE WHERE ID=7

    that's the most likely resolution to your bandwidth issue;, it might be something that needs to be done in order to improve your application;

     

     

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply