Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re^4: Improving on MS-SQL over DBI and DBD::ODBC

by bprew (Monk)
on Nov 25, 2004 at 22:24 UTC ( [id://410479]=note: print w/replies, xml ) Need Help??


in reply to Re^3: Improving on MS-SQL over DBI and DBD::ODBC
in thread Improving on MS-SQL over DBI and DBD::ODBC

Hmm... I have found in the past that you can make some good strides by looking at not only the SQL statement, but how its used in the context of the system.

The real question is, where are you spending your time? Is it in the SQL query itself, in the record fetching, in the comparison? If you're making a lot of small queries, perhaps there is a way to combine them into a few larger queries.

It sounds like you're fetching a fair amount of rows (60k+). Is there a way you can reduce the number of rows you're grabbing, perhaps by caching the data on the client side, so you don't have to grab all the data every time? Or allow the user to filter the data better, so they don't have to look at as much data?

Without knowing some of the business requirements and more about the environment, its hard to make pointed suggestions, but hopefully it can give you something to think about.


--
Ben
  • Comment on Re^4: Improving on MS-SQL over DBI and DBD::ODBC

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://410479]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (3)
As of 2024-04-20 09:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found