Re: SQL statements

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42564
interpreted = N
texte = At 10:13 14.08.2002, you wrote: >On 8/14/02 10:10 AM, Ben Swihart wrote: > > > Hm... How large is the database you're working with? Ours is 300mb. How > > fast is your server hardware? > >FYI, We've got a 400 meg database running in WebCatalog. I wouldn't >recommend it for every one, but it's working and keeps us from having to >muck with SQL. It's running on a Dual Xserve w/ 2 gigs of ram. > >-- > > Jesse Williams-Proudman || CEO > NineWire Digital Solutions || +1.888.873.6199 > jesse@ninewire.com || http://ninewire.com >Mac Web Hosting & Colocation || Mac Nationwide Dialup > > $75 Xserve Colocation Special from Your Mac ISP!A year ago I built a solution that connects to a SQL 2000 database containing around 2 GIG of data. We had to use stored procedures on the SQL-servers side for all queries and posts to the SQL-database. The reason for this was that we had major problems with standard SQL-requests. This was with WebCat 4 as far as i can remember. I had serious problems with SQL statements others that calling stored procedures. We compared the results we got with some ASP pages we built to compare, and got different results from ASP with the same queries. However, we stayed with the WebCat-solution because of the overall speed-benefits and the ease of programming in WebCat.------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: SQL statements (Jason Tyler 2002)
  2. Re: SQL statements (Ben Swihart 2002)
  3. Re: SQL statements (Bjørn Are Solstad 2002)
  4. Re: SQL statements (John Peacock 2002)
  5. Re: SQL statements (Jason Tyler 2002)
  6. Re: SQL statements (Clint Davis 2002)
  7. Re: SQL statements (dale's stuff 2002)
  8. Re: SQL statements (Jason Tyler 2002)
  9. Re: SQL statements (John Peacock 2002)
  10. Re: SQL statements (dale's stuff 2002)
  11. Re: SQL statements (Pedro Rivera 2002)
  12. Re: SQL statements (Jesse Williams-Proudman 2002)
  13. Re: SQL statements (Ben Swihart 2002)
  14. Re: SQL statements (Pedro Rivera 2002)
  15. SQL statements (Ben Swihart 2002)
At 10:13 14.08.2002, you wrote: >On 8/14/02 10:10 AM, Ben Swihart wrote: > > > Hm... How large is the database you're working with? Ours is 300mb. How > > fast is your server hardware? > >FYI, We've got a 400 meg database running in WebCatalog. I wouldn't >recommend it for every one, but it's working and keeps us from having to >muck with SQL. It's running on a Dual Xserve w/ 2 gigs of ram. > >-- > > Jesse Williams-Proudman || CEO > NineWire Digital Solutions || +1.888.873.6199 > jesse@ninewire.com || http://ninewire.com >Mac Web Hosting & Colocation || Mac Nationwide Dialup > > $75 Xserve Colocation Special from Your Mac ISP!A year ago I built a solution that connects to a SQL 2000 database containing around 2 GIG of data. We had to use stored procedures on the SQL-servers side for all queries and posts to the SQL-database. The reason for this was that we had major problems with standard SQL-requests. This was with WebCat 4 as far as i can remember. I had serious problems with SQL statements others that calling stored procedures. We compared the results we got with some ASP pages we built to compare, and got different results from ASP with the same queries. However, we stayed with the WebCat-solution because of the overall speed-benefits and the ease of programming in WebCat.------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Bjørn Are Solstad

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Protect vs Authenicate (1997) [WebDNA] HTML/OS vs. WebDNA ? (2008) Repeating Fields (1997) [WebDNA] Not even sure what to ask for help on. . . :( (2008) RAM to disk (2002) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Anyone have an invoicing system? (1999) Batch printing of web pages (2003) Help! WebCat2 bug (1997) bug in [SendMail] (1997) can you take a look (2003) Math inside [showif] (1998) Strange database format import (2000) Cart sweeper (2000) [WebDNA] Just a Sunday morning test (2014) OK, here goes... (1997) [SHOWIF AND/OR] (1997) Rhapsody? (1997) Dashes and dots in credit card (1998) Secure Server (1997)