Search Results

Search found 40 results on 2 pages for 'mestika'.

Page 2/2 | < Previous Page | 1 2 

• A question about indexes regarding to the gain of inserts & updates in database

  - by Mestika

  Hi, I’m having a question about the fine line between the gain of an index to a table there is growing steadily in size every month and the gain of queries with an index. The situation is, that I’ve two tables, Table1 and Table2. Each table grows slowly but regularly each month (with about 100 new rows for Table1 and a couple of rows for Table2).…

  Read the article

• Python: Time a code segment for testing performance (with timeit)

  - by Mestika

  Hi, I've a python script which works just as it should but I need to write the time for the execution. I've gooled that I should use timeit but I can't seem to get it to work. My Python script looks like this: import sys import getopt import timeit import random import os import re import ibm_db import time from string import maketrans myfile =…

  Read the article

• PHP: Loop through text file and isolate lines which a specific "starting point"

  - by Mestika

  Hi everyone, I’m trying to reduce some editing time within some textfiles where there approximately are 10.000 lines of text, but I only need around 200 or some. The text file relies on a almost specific pattern but it deviates from time to time but my “focus” in order to select the right line to keep is, that the line always starts with: z3455…

  Read the article

• DB2 increase bufferpool size and compressed tables not equal better performance. Why?

  - by Mestika

  Hi, I’m working on tuning and increasing the performance of my IBM DB2 version 9.7 database. I’ve been searching around the net for the last couple of days and learned that if I created my tables in COMPRESS mode and created one more bufferpool and set both of them to access 1024mb, then the performance in my queries should increase because of…

  Read the article

• PHP: Iterate through folders and display HTML contends

  - by Mestika

  Hi, I’m currently trying to develop a method to get a overview of all my different web templates I’ve created and (legally) downloaded over the years. I thought about a displaying them like Wordpress is previewing it’s templates view a small preview windows, displaying the concrete file with styles and everything. How to divide them into rows…

  Read the article

• Python: How to execute a SQL file or command

  - by Mestika

  Hi, I have this Python script: import sys import getopt import timeit import random import os import re import ibm_db import time from string import maketrans runs=5 queries=50 file = open("results.txt", "a") for r in range(5): print "Run %s\n" % r os.system("python reads.py -r1 -pquery1.sql -q50 -sespec") file.write('END QUERY…

  Read the article

• Help with Cygwin bash file

  - by Mestika

  Hi, I have a bash file, which I’m trying to run in Cygwin on a Windows 7 platform, but I gives me some odd errors when doing so. The bash file works on my Linux system. The bach file looks like this: for ((r=0; r <10; r++)) netcat localhost 4444 < myfile.file & done wait but I’m getting an error for my for-loop. More…

  Read the article

• Converting a bash script to python (small script)

  - by Mestika

  Hi, I’ve a bash script I’ve been using for a Linux environment but now I have to use it on a Windows platform and want to convert the bash script to a python script which I can run. The bash script is rather simple (I think) and I’ve tried to convert it by google by way around but can’t convert it successfully. The bash script looks…

  Read the article

• Help with SQL query (Calculate a ratio between two entitiess)

  - by Mestika

  Hi, I’m going to calculate a ratio between two entities but are having some trouble with the query. The principal is the same to, say a forum, where you say: A user gets points for every new thread. Then, calculate the ratio of points for the number of threads. Example: User A has 300 points. User A has started 6 thread. The point…

  Read the article

• Index question: Select * with WHERE clause. Where and how to create index

  - by Mestika

  Hi, I’m working on optimizing some of my queries and I have a query that states: select * from SC where c_id ="+c_id” The schema of ** SC** looks like this: SC ( c_id int not null, date_start date not null, date_stop date not null, r_t_id int not null, nt int, t_p decimal, PRIMARY KEY (c_id, r_t_id, date_start, date_stop)); …

  Read the article

• Update table instantly or “Bulk” Update in database later? And is it advisable?

  - by Mestika

  Hi, I have a question regarding a semi-constant update in a database. In short it is regarding a checkout function on a web page, which each time the checkout function is evoked it do five steps. I want to try to optimize this function and have my eye on a step where I update a table each time the checkout is performed. I take the…

  Read the article

• Align div boxes next to each other

  - by Mestika

  Hi everyone, I’ve two div boxes that I’m using as a expand-collapse with some javascript but the problem is that they currently are align underneath each other. I would like to have them next to each other instead but I’ve run into a wall. My styles look like this: <style type="text/css"> body { font-family: Verdana,…

  Read the article

• Exchange 2007: Auto reply message to senders (server side)

  - by Mestika

  I’ve a need to create an auto-reply for some of the users in my organization where, when a person sends an E-mail to e.g. user@myorg.com is faced with an automatically auto-reply with some message “closed during the holidays. We are back at… etc. etc. etc.”. I’ve tried to create a Transport Rule on our Exchange server but the…

  Read the article

• Keyboard not responding on startup

  - by Mestika

  I’m having a weird problem with one of the laptops at my work. Every now and then (not a systematic repeating pattern, but kind of random) the keyboard will not function on start up. The computer boots and it gets to the CTRL + ALT + DELETE screen and it is responding to nothing from the keyboard. The mouse works fine. I then…

  Read the article

• Help with SQL query (add 5% to users with conditions)

  - by Mestika

  Hi everyone, I’m having some difficulties with a query which purpose is to give users with more than one thread (called CS) in current year a 5% point “raise”. My relational schema looks like this: Thread = (threadid, threadname, threadLocation) threadoffering = (threadid, season, year, user) user = (name, points) Then,…

  Read the article

< Previous Page | 1 2