question of performance

Nemo

Hello Folks,
about the performance(speed) of a query, does it make difference if I define
my field type as string or integer. Thanks.

Nov 13 '05 #1

Subscribe Reply

1071

"Nemo" <al********@yahoo.ca> ha scritto nel messaggio
news:cm**********@dns3.cae.ca...

Hello Folks,
about the performance(speed) of a query, does it make difference if I define my field type as string or integer. Thanks.
Numeric, if indicizated is more fast.
MAssimiliano

Nov 13 '05 #2

Larry Linson

If you search on an indexed field, whether text or numeric, it will be
faster than if the same field was not indexed.

While the comparison operation on an integer will, indeed be somewhat
faster, I suspect the difference between a text field containing an integer
and an integer field containing the same integer would be so small that
you'd never see any difference sitting at the keyboard.

Larry Linson
Microsoft Access MVP
"MA" <ma****@massimilianoamendola.it> wrote in message
news:9s*******************@news.edisontel.com...

"Nemo" <al********@yahoo.ca> ha scritto nel messaggio
news:cm**********@dns3.cae.ca...
Hello Folks,
about the performance(speed) of a query, does it make difference if I

define
my field type as string or integer. Thanks.

Numeric, if indicizated is more fast.
MAssimiliano

Nov 13 '05 #3

by: Carlos Ribeiro | last post by:

As a side track of my latest investigations, I began to rely heavily on generators for some stuff where I would previsouly use a more conventional approach. Whenever I need to process a list, I'm...

Python

loop performance question

by: pertheli | last post by:

Hello, I have a large array of pointer to some object. I have to run test such that every possible pair in the array is tested. eg. if A,B,C,D are items of the array, possible pairs are AB, AC,...

C / C++

Performance Question: Variablize or reference direct???

by: Randell D. | last post by:

Folks, I have a Javascript performance question that I might have problems explaining... In PHP, better performance can be obtained dealing directly with a variable, as opposed to an element...

Javascript

Best Performance Practice Question

by: John | last post by:

I have a question about design, performance, and code reusability. Which one of these would be the best as far as performance/speed Send a textbox to a public class to check it and process/not...

C# / C Sharp

performance question

by: Mike | last post by:

Lets just say my app is done HOO HOO. Now, I'm accessing the database via a web service and one thing i noticed that my app is running real slow. When I first started working on the app is ran...

ASP.NET

Try Catch Question

by: Tiraman | last post by:

Hi , I am using allot the try catch in my code and the question is if it is good ? it will decrease my performance ? one more question

Visual Basic .NET

Sort array question

by: yeti349 | last post by:

Hi, I'm using the following code to retrieve data from an xml file and populate a javascript array. The data is then displayed in html table form. I would like to then be able to sort by each...

Javascript

Performance question - passing data between objects (PHP4-style OOP)

by: Markus Ernst | last post by:

Hello A class that composes the output of shop-related data gets some info from the main shop class. Now I wonder whether it is faster to store the info in the output class or get it from the...

PHP

c# interview question

by: =?Utf-8?B?U3RldmUgQnVnZGVu?= | last post by:

Hi, I recently had an interview where I was asked a number of questions on C#. Unfortunately I didn't get the answers from the test and find that one of them is still niggling me. It was...

C# / C Sharp

simple code performance question

by: galiorenye | last post by:

Hi, Given this code: A** ppA = new A*; A *pA = NULL; for(int i = 0; i < 10; ++i) { pA = ppA; //do something with pA

C / C++

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

Similar topics