Speed Rates

my asp pages use mysql db...i got 40 tables.
mostly the site system uses 7 tables only...
in the past i used access mdb database but after this 5 tables fulfilled with something like 10000 records it was so slow i could read a book before it moved...
then i moved to sql...

now the question is for who had/have asp pages connected to mysql with more than 50,000 records...
how is the speed? can you see the speed diffrence with the growing of numbers of records?
if i got slow speed when i ask my asp pages to show me some records, is that because i got more than normal number of records inside one table?
80,000 records inside one mysql table sounds to you normal?

View Replies


ADVERTISEMENT

Shipping Rates

I'm developing an e-commerc website and now that I am
working on the shipping portion, I wanted to know what is
the best way to get shipping rates so that they always
appear current on your website without using any
components.

View Replies View Related

Where Can I Get UK Mortgage Rates In Xml/rss?

anyone know a source of uk mortgage rates for different providers in one feed?

View Replies View Related

Conversion Rates And Vat

I want my site to show prices including VAT. How do I calculate this with vbscript. I also want users to be able to click on a button to convert the price to Euro/dollar/yen - how do I do this and can I use a live conversion rate without having to change it yself (eg get the current rate from a site to use tin the equations)?

View Replies View Related

Get Current Rates

i'd like to know if their is a way to get current rates to use them in an asp script that makes currency conversions?

View Replies View Related

UPS Rates Online Tools

I am trying to integrate UPS's Online Tools into my classic ASP project. Does anyone have some examples of this that I could look at? I am specifically looking for information on the "Rates and Service Selection" tool.

View Replies View Related

Calculate USPS Rates

Has anyone seen a decent script for getting USPS rates live in your own shopping cart?

View Replies View Related

Speed

If I want to get the number of rows returned from the database along with the contents, I would assume that GetRows() would be the best way, and then doing a UBound(myArray,2) + 1 would be the best way to give me the number of records.
If I do NOT need the actual database info, but I just need the number of rows, should I use GetRows or COUNT(ID) in my SQL or what?

View Replies View Related

ASP- Reliability Speed

I am about to implement an online auction system similar to ebay. I am debating between two products. One is PHP the other ASP (PHP Auction and Rainworx).

I typically like PHP better, because I've noticed ASP always seems to turn up an error (even on professional sites), but the ASP system has more of the features that I need.

Can anyone tell me the pros/cons of ASP vs. PHP? My largets concern is speed. Is ASP fast? and is it reliable? I've heard something about the code breaks down over time, etc.

View Replies View Related

Speed Up Query

I are there ANY secrets in sql 2000 to speed up this process on the webpage? I tried using indexes... expanding the timeout... it is still too big and we cannot archive any records.

View Replies View Related

How To Speed Up Code

I'm using get rows to build a table for a calendar. The specific view for this calendar is for an entire month. Each appointment slot is one half hour long. If I were to generate a page for the month of november I would have to check and see if an appointment is scheduled for each appointment slot throughout the entire month. this is 240 slots! At this point I've written it so it only checks for an appointment if a particular day has an appointment, even so, with only 20 or so appointments scheduled for the entire month, it's taking several seconds to return the results.

I was thinking it might be best to pay a javascript programmer to write a script that will parse through the whole mess to offload it onto the client. What would you recommend?

View Replies View Related

Speed Up Datasearch

The code below is searching a ms access database that contains approx 53,000 records. This code go's into the data and extracts the files pertaining to this customer but the scripts takes approx 40 + seconds to search. Is there something different I can do to speed up the process ? Code:

Dim rs, sql
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT Left(CUSTNOITEM, 4) as CustNo,Right(CUSTNOITEM, 9) as CustNoI,CLASS,descrip,SEQ_NO FROM ARCPRICQ WHERE Left(CUSTNOITEM, 4) = '" & Session("login") & "' ORDER BY " & Mysort & " ;"
rs.Open sql, db, adOpenForwardOnly, adLockOptimistic
While Not rs.EOF

View Replies View Related

Upload Speed Problem

currently using an asp upload to upload file into server, but finding it the transfer speed quite slow, anyone know the faster way or script to upload file into server in asp? or in other language?PHP?

View Replies View Related

Determine Connection Speed

Just wondering if anyone knows how to determine someones connection speed in asp the reason for this being so i can redirect the user to a different media file depending on their connection speed.

View Replies View Related

Client Connection Speed

is any idea to find client connection speed like google analytics report on connection?

View Replies View Related

Main Point Of Loading Speed

if a page always have some picture that totally have near 250k does this a main point of affect the loading speed?

View Replies View Related

How Can I Speed Up The Load Time On Page?

This page takes awhile to load which is probably due to the queries and the way I have it outputed. Anybody have any advice for speeding this up? Code:

View Replies View Related

How Can I Increase The Speed Of Sending Email By Asp

i m trying to write a script for sending email to many people at a time and i m getting the email addresses from database .my script is working but after sending to 8 or 9 people script timed out.

now how can i increase the speed of sending email almost to 60000 people.my script is here.

View Replies View Related

Speed Test/benchmark Page Generation

I'm pretty sure this is possible in ASP, something about making CPU time markers and then taking the difference and switching it into seconds/minutes I just don't recall how to go about doing it.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved