## Replace the ... text below with a title and a summary of the problem. ## Feel free to remove any remaining comments once you're done! = Asking for Help: Why is a query to Sybase slow after a Python version upgrade? = Python script running long after version upgrade(s) - querying to Sybase, so Sybase Module for Python involved ## Insert your problem description here. You may provide code samples using syntax like this: During server upgrades/refresh, we have upgrade FROM -> TO below: RedHat 4.3 (32-bit) -> 5.5 (64-bit) / Python 2.3.4 -> 2.4.3 / Sybase Module for Python (static) 0.39 -> 0.39 After this upgrade, a Python script used to query sybase tables and extract data and load back to RedHat server is taking 6x as long. Network settings have been compared from original server and new server, and network ports for original and new, all match and FTP transfers have ruled out the network configuration as a problem. Are there any known bugs/defects in Phython version 2.4.3 that could be resulting in our situation/experience? ---- If the server configuration has remained the same, then it quite possibly is something related to the client configuration, and maybe there is an issue with the client's network configuration (or how Python uses that configuration). Frequently, long delays involving network communications become introduced because of things like DNS queries, although this is often something which manifests itself on the server side (when a server process is writing hostnames to a log, for example). Network-related factors can also probably include things like routing (including firewall rules); other factors could include things like SELinux, I would imagine, and Red Hat do tend to encourage SELinux usage by default. I've looked on the bug tracker (http://bugs.python.org/) for network-related bugs, but I can't find much that suggests a change between 2.3 and 2.4, and I also looked at the [[http://docs.python.org/whatsnew/index.html|What's New]] documents. You might want to [[PythonSpeed/Profiling|profile]] your application, or at least use trace statements, to be sure of where the extra time is being spent, and I imagine that the developers of the [[Sybase]] interface would be the best people to ask about performance issues: Python 2.4 is rather old, and there has been plenty of time for user experiences on such matters to have been reported. -- PaulBoddie <> ---- CategoryAskingForHelp CategoryAskingForHelpAnswered